eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXT_TIME_PAY dependencies on PAY_ASSIGNMENT_LINK_USAGES_F

Line 902: -- We need to link to pay_assignment_link_usages for people_group eligibility.

898: AND nvl(ell.grade_id,nvl(asm.grade_id,-1)) = nvl(asm.grade_id,-1)
899: AND nvl(ell.position_id,nvl(asm.position_id,-1)) = nvl(asm.position_id,-1)
900: AND (nvl(ell.job_id, nvl(asm.job_id,-1)) = nvl(asm.job_id,-1))
901: --
902: -- We need to link to pay_assignment_link_usages for people_group eligibility.
903: --
904: AND (ell.people_group_id is null
905: OR EXISTS ( SELECT 1 FROM PAY_ASSIGNMENT_LINK_USAGES_F USAGE
906: WHERE USAGE.ASSIGNMENT_ID = ASM.ASSIGNMENT_ID

Line 905: OR EXISTS ( SELECT 1 FROM PAY_ASSIGNMENT_LINK_USAGES_F USAGE

901: --
902: -- We need to link to pay_assignment_link_usages for people_group eligibility.
903: --
904: AND (ell.people_group_id is null
905: OR EXISTS ( SELECT 1 FROM PAY_ASSIGNMENT_LINK_USAGES_F USAGE
906: WHERE USAGE.ASSIGNMENT_ID = ASM.ASSIGNMENT_ID
907: AND USAGE.ELEMENT_LINK_ID = ELL.ELEMENT_LINK_ID
908: AND G_DATE_WORKED BETWEEN USAGE.EFFECTIVE_START_DATE
909: AND USAGE.EFFECTIVE_END_DATE))