1023: hr_utility_trace ('ld_imp_date '|| ld_imp_date);
1024:
1025: SELECT fnd_date.date_to_canonical(MIN(creation_date))
1026: INTO ld_event_strt_date
1027: FROM pay_process_events ppe
1028: WHERE EXISTS
1029: (SELECT 1
1030: FROM pay_event_updates peu
1031: WHERE table_name IN ('PER_ALL_PEOPLE_F','PER_ALL_ASSIGNMENTS_F','PAY_ELEMENT_ENTRIES_F','PAY_ELEMENT_ENTRY_VALUES_F')