APPS.PSP_PSPENEXR_XMLP_PKG dependencies on PER_ALL_PEOPLE_F

Line 246: L_PERSON_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE;

242: FUNCTION CF_PERSON_NAMEFORMULA(PERSON_ID IN NUMBER
243: ,MAX_END_DATE IN DATE
244: ,MIN_START_DATE IN DATE) RETURN CHAR IS
245: L_DUMMY NUMBER;
246: L_PERSON_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE;
247: L_EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE;
248: CURSOR EMPLOYEE_CUR IS
249: SELECT
250: FULL_NAME,

Line 247: L_EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE;

243: ,MAX_END_DATE IN DATE
244: ,MIN_START_DATE IN DATE) RETURN CHAR IS
245: L_DUMMY NUMBER;
246: L_PERSON_NAME PER_ALL_PEOPLE_F.FULL_NAME%TYPE;
247: L_EMPLOYEE_NUMBER PER_ALL_PEOPLE_F.EMPLOYEE_NUMBER%TYPE;
248: CURSOR EMPLOYEE_CUR IS
249: SELECT
250: FULL_NAME,
251: EMPLOYEE_NUMBER,

Line 254: PER_ALL_PEOPLE_F PAPF

250: FULL_NAME,
251: EMPLOYEE_NUMBER,
252: 1 ORDER_BY
253: FROM
254: PER_ALL_PEOPLE_F PAPF
255: WHERE PAPF.PERSON_ID = CF_PERSON_NAMEFORMULA.PERSON_ID
256: AND PAPF.EFFECTIVE_START_DATE <= MAX_END_DATE
257: AND PAPF.EFFECTIVE_END_DATE >= MIN_START_DATE
258: AND ROWNUM = 1

Line 265: PER_ALL_PEOPLE_F PAPF

261: FULL_NAME,
262: EMPLOYEE_NUMBER,
263: 2 ORDER_BY
264: FROM
265: PER_ALL_PEOPLE_F PAPF
266: WHERE PAPF.PERSON_ID = CF_PERSON_NAMEFORMULA.PERSON_ID
267: AND PAPF.EFFECTIVE_START_DATE = (
268: SELECT
269: MAX(PAPF2.EFFECTIVE_START_DATE)

Line 271: PER_ALL_PEOPLE_F PAPF2

267: AND PAPF.EFFECTIVE_START_DATE = (
268: SELECT
269: MAX(PAPF2.EFFECTIVE_START_DATE)
270: FROM
271: PER_ALL_PEOPLE_F PAPF2
272: WHERE PAPF2.PERSON_ID = CF_PERSON_NAMEFORMULA.PERSON_ID )
273: ORDER BY
274: 3;
275: BEGIN