APPS.PER_PERUSHIR_XMLP_PKG dependencies on PER_PEOPLE_F

Line 313: V_PERSON_ID PER_PEOPLE_F.PERSON_ID%TYPE;

309: AND PPF.PER_INFORMATION7 IN ('INCL','INCLWH') --bug 14532612
310: ORDER BY
311: 2,
312: 3;
313: V_PERSON_ID PER_PEOPLE_F.PERSON_ID%TYPE;
314: V_LAST_NAME PER_PEOPLE_F.LAST_NAME%TYPE;
315: V_FIRST_NAME PER_PEOPLE_F.FIRST_NAME%TYPE;
316: BEGIN
317:

Line 314: V_LAST_NAME PER_PEOPLE_F.LAST_NAME%TYPE;

310: ORDER BY
311: 2,
312: 3;
313: V_PERSON_ID PER_PEOPLE_F.PERSON_ID%TYPE;
314: V_LAST_NAME PER_PEOPLE_F.LAST_NAME%TYPE;
315: V_FIRST_NAME PER_PEOPLE_F.FIRST_NAME%TYPE;
316: BEGIN
317:
318: SET_LOCATION('Entered p_update_status'

Line 315: V_FIRST_NAME PER_PEOPLE_F.FIRST_NAME%TYPE;

311: 2,
312: 3;
313: V_PERSON_ID PER_PEOPLE_F.PERSON_ID%TYPE;
314: V_LAST_NAME PER_PEOPLE_F.LAST_NAME%TYPE;
315: V_FIRST_NAME PER_PEOPLE_F.FIRST_NAME%TYPE;
316: BEGIN
317:
318: SET_LOCATION('Entered p_update_status'
319: ,5);

Line 331: PER_PEOPLE_F

327: V_PERSON_ID
328: ,V_LAST_NAME
329: ,V_FIRST_NAME;
330: UPDATE
331: PER_PEOPLE_F
332: SET
333: PER_INFORMATION7 = 'DONE'
334: WHERE PERSON_ID = V_PERSON_ID
335: AND PER_INFORMATION7 IN ('INCL','INCLWH'); --bug 14532612