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.PAY_IN_UTILS dependencies on PAY_ASSIGNMENT_LINK_USAGES_F

Line 1057: FROM pay_assignment_link_usages_f

1053: ,p_effective_date DATE
1054: )
1055: IS
1056: SELECT 1
1057: FROM pay_assignment_link_usages_f
1058: WHERE assignment_id = p_assignment_id
1059: AND element_link_id = p_element_link_id
1060: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1061:

Line 1195: EXISTS ( SELECT 1 FROM pay_assignment_link_usages_f usage

1191: AND (link.location_id = assgn.location_id OR link.location_id IS NULL)
1192: AND (link.pay_basis_id = assgn.pay_basis_id OR link.pay_basis_id IS NULL)
1193: AND (link.employment_category = assgn.employment_category OR link.employment_category IS NULL)
1194: AND (link.people_group_id IS NULL OR
1195: EXISTS ( SELECT 1 FROM pay_assignment_link_usages_f usage
1196: WHERE usage.assignment_id = assgn.assignment_id
1197: AND usage.element_link_id = link.element_link_id
1198: AND p_effective_date BETWEEN usage.effective_start_date AND usage.effective_end_date
1199: ))