DBA Data[Home] [Help]

APPS.IRC_PURGE_OLD_DATA_PKG dependencies on PER_ESTABLISHMENT_ATTENDANCES

Line 278: from per_establishment_attendances

274: where party_id = p_party_id;
275: --
276: cursor csr_per_est_att is
277: select attendance_id, object_version_number
278: from per_establishment_attendances
279: where party_id = p_party_id;
280: --
281: cursor csr_per_prev_empl is
282: select previous_employer_id, object_version_number

Line 433: -- Delete from PER_ESTABLISHMENT_ATTENDANCES

429: ,p_object_version_number => rec_per_qual.object_version_number
430: );
431: end loop;
432: --
433: -- Delete from PER_ESTABLISHMENT_ATTENDANCES
434: -- There should not be a child record in Per Qualification table mapped
435: -- by Attendance ID
436: --
437: hr_utility.set_location(l_proc, 30);

Line 715: per_establishment_attendances esa,

711: irc_documents ido,
712: irc_search_criteria iscp,
713: irc_search_criteria iscw,
714: per_previous_employers pem,
715: per_establishment_attendances esa,
716: per_qualifications qua,
717: per_competence_elements pce,
718: irc_job_basket_items jbo,
719: per_all_people_f per1,