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 860: -- We need to link to pay_assignment_link_usages for people_group eligibility.

856: AND nvl(ell.grade_id,nvl(asm.grade_id,-1)) = nvl(asm.grade_id,-1)
857: AND nvl(ell.position_id,nvl(asm.position_id,-1)) = nvl(asm.position_id,-1)
858: AND (nvl(ell.job_id, nvl(asm.job_id,-1)) = nvl(asm.job_id,-1))
859: --
860: -- We need to link to pay_assignment_link_usages for people_group eligibility.
861: --
862: AND (ell.people_group_id is null
863: OR EXISTS ( SELECT 1 FROM PAY_ASSIGNMENT_LINK_USAGES_F USAGE
864: WHERE USAGE.ASSIGNMENT_ID = ASM.ASSIGNMENT_ID

Line 863: OR EXISTS ( SELECT 1 FROM PAY_ASSIGNMENT_LINK_USAGES_F USAGE

859: --
860: -- We need to link to pay_assignment_link_usages for people_group eligibility.
861: --
862: AND (ell.people_group_id is null
863: OR EXISTS ( SELECT 1 FROM PAY_ASSIGNMENT_LINK_USAGES_F USAGE
864: WHERE USAGE.ASSIGNMENT_ID = ASM.ASSIGNMENT_ID
865: AND USAGE.ELEMENT_LINK_ID = ELL.ELEMENT_LINK_ID
866: AND G_DATE_WORKED BETWEEN USAGE.EFFECTIVE_START_DATE
867: AND USAGE.EFFECTIVE_END_DATE))