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 1125: ,pay_event_updates peu

1121:
1122: CURSOR c_IDW_events IS
1123: SELECT ppe.effective_date
1124: FROM pay_process_events ppe
1125: ,pay_event_updates peu
1126: ,pay_dated_tables pdt
1127: ,pay_element_entry_values_f peev
1128: ,pay_input_values_f piv
1129: ,pay_element_types_f pet

Line 1154: ,pay_event_updates peu

1150: UNION
1151: -- Bug 5002283
1152: SELECT ppe.effective_date
1153: FROM pay_process_events ppe
1154: ,pay_event_updates peu
1155: ,pay_dated_tables pdt
1156: ,pay_element_entries_f pee
1157: ,pay_element_types_f pet
1158: WHERE ppe.business_group_id = p_business_group_id

Line 1192: ,pay_event_updates peu

1188: ,ppe.surrogate_key element_entry_id
1189: ,ppe.calculation_date
1190: ,peu.event_type
1191: FROM pay_process_events ppe
1192: ,pay_event_updates peu
1193: ,pay_dated_tables pdt
1194: WHERE ppe.business_group_id = cp_business_group_id
1195: AND ppe.assignment_id = cp_assignment_id
1196: AND ppe.change_type = 'DATE_EARNED'

Line 1445: pay_event_updates peu ,

1441: CURSOR c_first_sal_date IS
1442:
1443: SELECT max(ppe.effective_date)
1444: FROM pay_process_events ppe ,
1445: pay_event_updates peu ,
1446: pay_dated_tables pdt
1447: WHERE ppe.business_group_id = p_business_group_id
1448: AND ppe.assignment_id = p_assignment_id
1449: AND ppe.change_type = 'DATE_EARNED'