DBA Data[Home] [Help]

APPS.PER_MX_SSAFFL_ARCHIVE dependencies on PAY_DATETRACKED_EVENTS

Line 533: pay_datetracked_events pde

529:
530: lv_sql_string := 'select distinct ppe.assignment_id
531: from pay_process_events ppe,
532: pay_event_updates peu,
533: pay_datetracked_events pde
534: where ppe.creation_date between
535: fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(ld_start_date) || ''')
536: and fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(ld_end_date) || ''')
537: and ppe.event_update_id = peu.event_update_id

Line 635: pay_datetracked_events pde,

631: -- ,paf.person_id,
632: -- ,per_mx_ssaffl_archive.derive_gre_from_loc_scl(paf.location_id,paf.business_group_id,paf.soft_coding_keyflex_id,ppe.effective_date)
633: from pay_process_events ppe,
634: pay_event_updates peu,
635: pay_datetracked_events pde,
636: per_all_assignments_f paf
637: where ppe.creation_date between cp_start_date and cp_end_date
638: and peu.event_update_id = ppe.event_update_id
639: and ppe.business_group_id = cp_business_group_id