DBA Data[Home] [Help]

APPS.IRC_PURGE_OLD_DATA_PKG dependencies on PER_ESTABLISHMENT_ATTENDANCES

Line 275: from per_establishment_attendances

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

Line 349: -- Delete from PER_ESTABLISHMENT_ATTENDANCES

345: ,p_object_version_number => rec_per_qual.object_version_number
346: );
347: end loop;
348: --
349: -- Delete from PER_ESTABLISHMENT_ATTENDANCES
350: -- There should not be a child record in Per Qualification table mapped
351: -- by Attendance ID
352: --
353: hr_utility.set_location(l_proc, 30);

Line 588: per_establishment_attendances esa,

584: irc_documents ido,
585: irc_search_criteria iscp,
586: irc_search_criteria iscw,
587: per_previous_employers pem,
588: per_establishment_attendances esa,
589: per_qualifications qua,
590: per_competence_elements pce,
591: irc_job_basket_items jbo,
592: per_all_people_f per1,