DBA Data[Home] [Help]

APPS.PA_PERSON dependencies on PA_EXPENDITURES

Line 311: from pa_expenditures pa

307: into v_delete_permitted
308: from sys.dual
309: where not exists (
310: select null
311: from pa_expenditures pa
312: where pa.incurred_by_person_id = P_PERSON_ID);
313:
314: select 'Y'
315: into v_delete_permitted

Line 319: from pa_expenditures pa

315: into v_delete_permitted
316: from sys.dual
317: where not exists (
318: select null
319: from pa_expenditures pa
320: where pa.entered_by_person_id = P_PERSON_ID);
321: exception
322: when NO_DATA_FOUND then
323: hr_utility.set_message (801, 'HR_6300_ALL_PA9_PER_NO_DEL');