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_MX_SOC_SEC_ARCHIVE dependencies on PAY_EVENT_UPDATES

Line 1200: ,pay_event_updates peu

1196:
1197: CURSOR c_IDW_events IS
1198: SELECT ppe.effective_date
1199: FROM pay_process_events ppe
1200: ,pay_event_updates peu
1201: ,pay_dated_tables pdt
1202: ,pay_element_entry_values_f peev
1203: ,pay_input_values_f piv
1204: ,pay_element_types_f pet

Line 1229: ,pay_event_updates peu

1225: UNION
1226: -- Bug 5002283
1227: SELECT ppe.effective_date
1228: FROM pay_process_events ppe
1229: ,pay_event_updates peu
1230: ,pay_dated_tables pdt
1231: ,pay_element_entries_f pee
1232: ,pay_element_types_f pet
1233: WHERE ppe.business_group_id = p_business_group_id

Line 1267: ,pay_event_updates peu

1263: ,ppe.surrogate_key element_entry_id
1264: ,ppe.calculation_date
1265: ,peu.event_type
1266: FROM pay_process_events ppe
1267: ,pay_event_updates peu
1268: ,pay_dated_tables pdt
1269: WHERE ppe.business_group_id = cp_business_group_id
1270: AND ppe.assignment_id = cp_assignment_id
1271: AND ppe.change_type = 'DATE_EARNED'

Line 1530: pay_event_updates peu ,

1526: CURSOR c_first_sal_date IS
1527:
1528: SELECT max(ppe.effective_date)
1529: FROM pay_process_events ppe ,
1530: pay_event_updates peu ,
1531: pay_dated_tables pdt
1532: WHERE ppe.business_group_id = p_business_group_id
1533: AND ppe.assignment_id = p_assignment_id
1534: AND ppe.change_type = 'DATE_EARNED'