DBA Data[Home] [Help]

APPS.PAY_MX_SSAFFL_SALARY dependencies on PAY_PROCESS_EVENTS

Line 508: from pay_process_events ppe,

504:
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,

Line 553: from pay_process_events ppe,

549: lv_sql_string := 'select paf1.person_id
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,

Line 647: from pay_process_events ppe,

643: ,cp_end_date in date
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,

Line 700: from pay_process_events ppe,

696: select x.assignment_id
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,

Line 1318: from pay_process_events ppe,

1314: ,cp_end_date in date
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,