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 1074: FROM pay_assignment_link_usages_f

1070: ,p_effective_date DATE
1071: )
1072: IS
1073: SELECT 1
1074: FROM pay_assignment_link_usages_f
1075: WHERE assignment_id = p_assignment_id
1076: AND element_link_id = p_element_link_id
1077: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
1078:

Line 1210: EXISTS ( SELECT 1 FROM pay_assignment_link_usages_f usage

1206: AND (link.location_id = assgn.location_id OR link.location_id IS NULL)
1207: AND (link.pay_basis_id = assgn.pay_basis_id OR link.pay_basis_id IS NULL)
1208: AND (link.employment_category = assgn.employment_category OR link.employment_category IS NULL)
1209: AND (link.people_group_id IS NULL OR
1210: EXISTS ( SELECT 1 FROM pay_assignment_link_usages_f usage
1211: WHERE usage.assignment_id = assgn.assignment_id
1212: AND usage.element_link_id = link.element_link_id
1213: AND p_effective_date BETWEEN usage.effective_start_date AND usage.effective_end_date
1214: ))