APPS.PAY_MX_SSAFFL_SALARY dependencies on PAY_ELEMENT_ENTRIES_F

Line 511: pay_element_entries_f pee,

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
515: where ppe.creation_date between

Line 556: pay_element_entries_f pee,

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
560: where ppe.creation_date between

Line 580: from pay_element_entries_f pee,

576: and paf.assignment_id = ppe.assignment_id
577: and ppe.effective_date between paf.effective_start_date and paf.effective_end_date
578: union
579: select distinct pee.assignment_id
580: from pay_element_entries_f pee,
581: pay_element_type_extra_info petei
582: where pee.effective_start_date between
583: fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(ld_period_start_date) || ''')
584: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(ld_period_end_date) || ''')

Line 650: pay_element_entries_f pee,

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
654: where ppe.creation_date between cp_start_date and cp_end_date

Line 703: pay_element_entries_f pee,

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
707: where ppe.creation_date between cp_start_date and cp_end_date

Line 725: from pay_element_entries_f pee,

721: and paf.assignment_id = ppe.assignment_id
722: and ppe.effective_date between paf.effective_start_date and paf.effective_end_date
723: union
724: select distinct pee.assignment_id
725: from pay_element_entries_f pee,
726: pay_element_type_extra_info petei
727: where pee.effective_start_date between cp_period_start_date and cp_period_end_date
728: and petei.element_type_id = pee.element_type_id
729: and petei.eei_information_category='PQP_UK_RATE_TYPE'

Line 1321: pay_element_entries_f pee,

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
1325: and ppe.creation_date between cp_start_date and cp_end_date