DBA Data[Home] [Help]

APPS.PER_PERUSHIR_XMLP_PKG dependencies on PER_PEOPLE_F

Line 282: V_PERSON_ID PER_PEOPLE_F.PERSON_ID%TYPE;

278: AND PPF.PER_INFORMATION7 = 'INCL'
279: ORDER BY
280: 2,
281: 3;
282: V_PERSON_ID PER_PEOPLE_F.PERSON_ID%TYPE;
283: V_LAST_NAME PER_PEOPLE_F.LAST_NAME%TYPE;
284: V_FIRST_NAME PER_PEOPLE_F.FIRST_NAME%TYPE;
285: BEGIN
286:

Line 283: V_LAST_NAME PER_PEOPLE_F.LAST_NAME%TYPE;

279: ORDER BY
280: 2,
281: 3;
282: V_PERSON_ID PER_PEOPLE_F.PERSON_ID%TYPE;
283: V_LAST_NAME PER_PEOPLE_F.LAST_NAME%TYPE;
284: V_FIRST_NAME PER_PEOPLE_F.FIRST_NAME%TYPE;
285: BEGIN
286:
287: SET_LOCATION('Entered p_update_status'

Line 284: V_FIRST_NAME PER_PEOPLE_F.FIRST_NAME%TYPE;

280: 2,
281: 3;
282: V_PERSON_ID PER_PEOPLE_F.PERSON_ID%TYPE;
283: V_LAST_NAME PER_PEOPLE_F.LAST_NAME%TYPE;
284: V_FIRST_NAME PER_PEOPLE_F.FIRST_NAME%TYPE;
285: BEGIN
286:
287: SET_LOCATION('Entered p_update_status'
288: ,5);

Line 300: PER_PEOPLE_F

296: V_PERSON_ID
297: ,V_LAST_NAME
298: ,V_FIRST_NAME;
299: UPDATE
300: PER_PEOPLE_F
301: SET
302: PER_INFORMATION7 = 'DONE'
303: WHERE PERSON_ID = V_PERSON_ID
304: AND PER_INFORMATION7 = 'INCL';