DBA Data[Home] [Help]

APPS.PSP_PSPENCDU_XMLP_PKG dependencies on PER_ALL_PEOPLE_F

Line 121: PER_ALL_PEOPLE_F PAF1

117: SELECT
118: PAF1.EMPLOYEE_NUMBER
119: INTO V_EMPLOYEE_NUMBER
120: FROM
121: PER_ALL_PEOPLE_F PAF1
122: WHERE PERSON_ID = CF_EMPLOYEE_NUMBERFORMULA.PERSON_ID
123: AND EFFECTIVE_START_DATE = (
124: SELECT
125: MIN(EFFECTIVE_START_DATE)

Line 127: PER_ALL_PEOPLE_F PAF2

123: AND EFFECTIVE_START_DATE = (
124: SELECT
125: MIN(EFFECTIVE_START_DATE)
126: FROM
127: PER_ALL_PEOPLE_F PAF2
128: WHERE PAF1.PERSON_ID = PAF2.PERSON_ID
129: AND PAF2.CURRENT_EMPLOYEE_FLAG = 'Y' );
130: RETURN (V_EMPLOYEE_NUMBER);
131: EXCEPTION