DBA Data[Home] [Help]

APPS.PER_MX_SSAFFL_ARCHIVE dependencies on PAY_PROCESS_EVENTS

Line 531: from pay_process_events ppe,

527: dbg('Dynamic triggers Enabled' ) ;
528: close c_chk_dyn_triggers_enabled ;
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) || ''')

Line 633: from pay_process_events ppe,

629: ) is
630: select distinct ppe.assignment_id
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