APPS.PAY_MX_SSAFFL_SALARY dependencies on PER_ALL_ASSIGNMENTS_F

Line 514: per_all_assignments_f paf

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
516: fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(ld_start_date) || ''')
517: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(ld_end_date) || ''')
518: and peu.event_update_id =ppe.event_update_id

Line 559: per_all_assignments_f paf

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
561: fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(ld_start_date) || ''')
562: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(ld_end_date) || ''')
563: and peu.event_update_id =ppe.event_update_id

Line 589: per_all_assignments_f paf1

585: and petei.element_type_id = pee.element_type_id
586: and petei.eei_information_category=''PQP_UK_RATE_TYPE''
587: and petei.eei_information1=''MX_IDWV''
588: ) x,
589: per_all_assignments_f paf1
590: where x.assignment_id = paf1.assignment_id
591: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(ld_period_end_date) || ''')
592: between paf1.effective_start_date and paf1.effective_end_date
593: and (( per_mx_ssaffl_archive.derive_gre_from_loc_scl(paf1.location_id,paf1.business_group_id,paf1.soft_coding_keyflex_id,

Line 653: per_all_assignments_f paf

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
655: and peu.event_update_id =ppe.event_update_id
656: and peu.dated_table_id = pde.dated_table_id
657: and pde.event_group_id = cp_event_group_id

Line 706: per_all_assignments_f paf

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
708: and peu.event_update_id =ppe.event_update_id
709: and peu.dated_table_id = pde.dated_table_id
710: and pde.event_group_id = cp_event_group_id

Line 732: per_all_assignments_f paf1

728: and petei.element_type_id = pee.element_type_id
729: and petei.eei_information_category='PQP_UK_RATE_TYPE'
730: and petei.eei_information1='MX_IDWV'
731: ) x,
732: per_all_assignments_f paf1
733: where x.assignment_id = paf1.assignment_id
734: and paf1.person_id between cp_start_person_id and cp_end_person_id
735: and cp_period_end_date between paf1.effective_start_date and paf1.effective_end_date
736: and (( per_mx_ssaffl_archive.derive_gre_from_loc_scl(paf1.location_id,paf1.business_group_id,paf1.soft_coding_keyflex_id,

Line 1006: from per_all_assignments_f paf,

1002: ,puc.user_column_name work_schedule
1003: ,per_information4 med_center
1004: ,employee_number worker_id
1005: ,national_identifier CURP
1006: from per_all_assignments_f paf,
1007: per_all_people_f ppf,
1008: hr_soft_coding_keyflex hsc,
1009: pay_user_columns puc
1010: where paf.assignment_id = cp_assignment_id

Line 1347: from per_all_assignments_f paf,

1343: is
1344: select location_code ,
1345: assignment_number,
1346: per_mx_ssaffl_archive.derive_gre_from_loc_scl(paf.location_id,paf.business_group_id,paf.soft_coding_keyflex_id,cp_effective_date)
1347: from per_all_assignments_f paf,
1348: hr_locations hrl
1349: where paf.assignment_id = cp_assignment_id
1350: and cp_effective_date between paf.effective_start_date and paf.effective_end_date
1351: and hrl.location_id = paf.location_id ;