APPS.PSP_PSPLSEMP_XMLP_PKG dependencies on PER_PEOPLE_F

Line 30: PER_PEOPLE_F PPF1

26: CURSOR EMP_NAME_CUR IS
27: SELECT
28: FULL_NAME
29: FROM
30: PER_PEOPLE_F PPF1
31: WHERE PPF1.PERSON_ID = PERSON_ID_V
32: AND PPF1.CURRENT_EMPLOYEE_FLAG = 'Y'
33: AND ( TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE
34: AND EFFECTIVE_END_DATE

Line 39: PER_PEOPLE_F PPF2

35: OR TRUNC(SYSDATE) < (
36: SELECT
37: MIN(PPF2.EFFECTIVE_START_DATE)
38: FROM
39: PER_PEOPLE_F PPF2
40: WHERE PPF2.PERSON_ID = PPF1.PERSON_ID
41: AND PPF2.CURRENT_EMPLOYEE_FLAG = 'Y' ) );
42: L_EMP_NAME VARCHAR2(240);
43: BEGIN