APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on PAY_DATED_TABLES

Line 1126: ,pay_dated_tables pdt

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

Line 1155: ,pay_dated_tables pdt

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

Line 1193: ,pay_dated_tables pdt

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

Line 1446: pay_dated_tables pdt

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

Line 4961: FROM pay_dated_tables;

4957:
4958: CURSOR c_dated_tables IS
4959: SELECT dated_table_id
4960: ,table_name
4961: FROM pay_dated_tables;
4962:
4963: CURSOR c_payroll_Action_info (cp_payroll_action_id IN NUMBER) IS
4964: SELECT pay_mx_utility.get_legi_param_val('GRE',
4965: LEGISLATIVE_PARAMETERS) GRE,