APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on PAY_DATED_TABLES

Line 1201: ,pay_dated_tables pdt

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
1205: WHERE ppe.business_group_id = p_business_group_id

Line 1230: ,pay_dated_tables pdt

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
1234: AND ppe.assignment_id = p_assignment_id

Line 1268: ,pay_dated_tables pdt

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'
1272: AND ppe.creation_date BETWEEN cp_start_date

Line 1531: pay_dated_tables pdt

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'
1535: AND peu.event_update_id = ppe.event_update_id

Line 5428: FROM pay_dated_tables;

5424:
5425: CURSOR c_dated_tables IS
5426: SELECT dated_table_id
5427: ,table_name
5428: FROM pay_dated_tables;
5429:
5430: CURSOR c_payroll_Action_info (cp_payroll_action_id IN NUMBER) IS
5431: SELECT pay_mx_utility.get_legi_param_val('GRE',
5432: LEGISLATIVE_PARAMETERS) GRE,