DBA Data[Home] [Help]

APPS.PAY_MX_SSAFFL_SALARY dependencies on PAY_EVENT_UPDATES

Line 510: pay_event_updates peu,

506:
507: lv_sql_string := 'select distinct paf.person_id
508: from pay_process_events ppe,
509: pay_datetracked_events pde,
510: pay_event_updates peu,
511: pay_element_entries_f pee,
512: pay_element_types_f pet,
513: pay_element_type_extra_info petei,
514: per_all_assignments_f paf

Line 555: pay_event_updates peu,

551: (
552: select distinct paf.assignment_id
553: from pay_process_events ppe,
554: pay_datetracked_events pde,
555: pay_event_updates peu,
556: pay_element_entries_f pee,
557: pay_element_types_f pet,
558: pay_element_type_extra_info petei,
559: per_all_assignments_f paf

Line 649: pay_event_updates peu,

645: ) is
646: select distinct ppe.assignment_id
647: from pay_process_events ppe,
648: pay_datetracked_events pde,
649: pay_event_updates peu,
650: pay_element_entries_f pee,
651: pay_element_types_f pet,
652: pay_element_type_extra_info petei,
653: per_all_assignments_f paf

Line 702: pay_event_updates peu,

698: (
699: select distinct paf.assignment_id
700: from pay_process_events ppe,
701: pay_datetracked_events pde,
702: pay_event_updates peu,
703: pay_element_entries_f pee,
704: pay_element_types_f pet,
705: pay_element_type_extra_info petei,
706: per_all_assignments_f paf

Line 1320: pay_event_updates peu,

1316: ) is
1317: select max(ppe.effective_date)
1318: from pay_process_events ppe,
1319: pay_datetracked_events pde,
1320: pay_event_updates peu,
1321: pay_element_entries_f pee,
1322: pay_element_types_f pet,
1323: pay_element_type_extra_info petei
1324: where ppe.assignment_id = cp_assignment_id