APPS.GHR_EXEMP_PURGE dependencies on PER_PERSON_TYPE_USAGES_F

Line 348: FROM PER_PERSON_TYPE_USAGES_F ptu

344: hr_utility.set_location(g_proc, 20);
345: -- check if person type changes exist.
346: SELECT count(*)
347: INTO l_person_types
348: FROM PER_PERSON_TYPE_USAGES_F ptu
349: WHERE ptu.person_id = p_person_id
350: AND ptu.effective_start_date >= p_effective_date;
351:
352: IF l_person_types > 0 then