APPS.HR_RO_PERSON_VALIDATE dependencies on PER_ALL_PEOPLE_F

Line 273: FROM PER_ALL_PEOPLE_F

269: SELECT BUSINESS_GROUP_ID,
270: ORIGINAL_DATE_OF_HIRE
271: INTO l_BUSINESS_GROUP_ID,
272: l_HIRE_DATE
273: FROM PER_ALL_PEOPLE_F
274: WHERE PERSON_ID = P_PERSON_ID
275: AND P_EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
276: EXCEPTION
277: WHEN OTHERS THEN

Line 286: FROM PER_ALL_PEOPLE_F

282: IF (p_national_identifier = hr_api.g_varchar2) THEN
283: BEGIN
284: SELECT national_identifier
285: INTO l_national_identifier
286: FROM PER_ALL_PEOPLE_F
287: WHERE PERSON_ID = P_PERSON_ID
288: AND P_EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
289: EXCEPTION
290: WHEN OTHERS THEN

Line 300: FROM PER_ALL_PEOPLE_F

296: IF (p_sex = hr_api.g_varchar2) THEN
297: BEGIN
298: SELECT sex
299: INTO l_sex
300: FROM PER_ALL_PEOPLE_F
301: WHERE PERSON_ID = P_PERSON_ID
302: AND P_EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
303: EXCEPTION
304: WHEN OTHERS THEN

Line 314: FROM PER_ALL_PEOPLE_F

310: IF (p_country_of_birth = hr_api.g_varchar2) THEN
311: BEGIN
312: SELECT country_of_birth
313: INTO l_country_of_birth
314: FROM PER_ALL_PEOPLE_F
315: WHERE PERSON_ID = P_PERSON_ID
316: AND P_EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
317: EXCEPTION
318: WHEN OTHERS THEN

Line 328: FROM PER_ALL_PEOPLE_F

324: IF (p_region_of_birth = hr_api.g_varchar2) THEN
325: BEGIN
326: SELECT region_of_birth
327: INTO l_region_of_birth
328: FROM PER_ALL_PEOPLE_F
329: WHERE PERSON_ID = P_PERSON_ID
330: AND P_EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
331: EXCEPTION
332: WHEN OTHERS THEN

Line 342: FROM PER_ALL_PEOPLE_F

338: IF (p_per_information1 = hr_api.g_varchar2) THEN
339: BEGIN
340: SELECT per_information1
341: INTO l_per_information1
342: FROM PER_ALL_PEOPLE_F
343: WHERE PERSON_ID = P_PERSON_ID
344: AND P_EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
345: EXCEPTION
346: WHEN OTHERS THEN

Line 356: FROM PER_ALL_PEOPLE_F

352: IF (p_per_information2 = hr_api.g_varchar2) THEN
353: BEGIN
354: SELECT per_information2
355: INTO l_per_information2
356: FROM PER_ALL_PEOPLE_F
357: WHERE PERSON_ID = P_PERSON_ID
358: AND P_EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
359: EXCEPTION
360: WHEN OTHERS THEN

Line 370: FROM PER_ALL_PEOPLE_F

366: IF (p_per_information4 = hr_api.g_varchar2) THEN
367: BEGIN
368: SELECT per_information4
369: INTO l_per_information4
370: FROM PER_ALL_PEOPLE_F
371: WHERE PERSON_ID = P_PERSON_ID
372: AND P_EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;
373: EXCEPTION
374: WHEN OTHERS THEN