DBA Data[Home] [Help]

APPS.PAY_MX_SSAFFL_SALARY dependencies on PAY_DATETRACKED_EVENTS

Line 509: pay_datetracked_events pde,

505: if lv_report_mode = 'F' then -- Fixed Salary
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,

Line 554: pay_datetracked_events pde,

550: from
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,

Line 648: pay_datetracked_events pde,

644: ,cp_event_group_id in number
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,

Line 701: pay_datetracked_events pde,

697: from
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,

Line 1319: pay_datetracked_events pde,

1315: ,cp_event_group_id in number
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