SELECT DISTINCT
AAP.BASE_NAME ABSENCE_PLAN_NAME
,PDDF.BASE_COMPONENT_NAME ABSENCE_ELEMENT_NAME
FROM ANC_ABSENCE_PLANS_F AAP,
PAY_GI_MAPPINGS PGM,
PAY_DIR_CARD_COMP_DEFS_F PDDF
WHERE AAP.PAYROLL_MAPPING_ID = PGM.MAPPING_ID
AND PDDF.DIR_CARD_COMP_DEF_ID= PGM.SECONDARY_ENTITY_ID
AND TRUNC(SYSDATE) BETWEEN PDDF.EFFECTIVE_START_DATE AND PDDF.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN AAP.EFFECTIVE_START_DATE AND AAP.EFFECTIVE_END_DATE
Related Posts
Mobile app time entry – Employee
Posted on
