APPS.PA_PERSON dependencies on PA_CREDIT_RECEIVERS

Line 289: select /*+ INDEX (pa PA_CREDIT_RECEIVERS_U1) */

285: --
286: hr_utility.set_location('PA_PERSON.PA_PREDEL_VALIDATION', 8);
287: --
288: begin
289: select /*+ INDEX (pa PA_CREDIT_RECEIVERS_U1) */
290: 'Y'
291: into v_delete_permitted
292: from sys.dual
293: where not exists (

Line 295: from pa_credit_receivers pa

291: into v_delete_permitted
292: from sys.dual
293: where not exists (
294: select null
295: from pa_credit_receivers pa
296: where pa.person_id = P_PERSON_ID);
297: exception
298: when NO_DATA_FOUND then
299: hr_utility.set_message (801, 'HR_6297_ALL_PA8_PER_NO_DEL');