DBA Data[Home] [Help]

APPS.PA_AGREEMENT_CORE dependencies on PA_EMPLOYEES

Line 215: select 0 from pa_employees

211: person_id_exists number;
212: BEGIN
213: select 1 into Person_Id_Exists
214: from Dual Where Exists (
215: select 0 from pa_employees
216: where person_id = p_owned_by_person_id);
217: IF Person_Id_Exists = 1
218: THEN RETURN 'Y';
219: END IF;