APPS.PSP_PSPLSODL_XMLP_PKG dependencies on PER_PEOPLE_F

Line 157: PER_PEOPLE_F

153: DISTINCT
154: FULL_NAME
155: INTO V_EMPLOYEE_NAME
156: FROM
157: PER_PEOPLE_F
158: WHERE PERSON_ID = PERSON_ID_V
159: AND ( V_TIME_PERIOD_END Between EFFECTIVE_START_DATE
160: AND EFFECTIVE_END_DATE );
161: ELSE

Line 167: PER_PEOPLE_F

163: DISTINCT
164: FULL_NAME
165: INTO V_EMPLOYEE_NAME
166: FROM
167: PER_PEOPLE_F
168: WHERE PERSON_ID = PERSON_ID_V;
169: END IF;
170: RETURN V_EMPLOYEE_NAME;
171: RETURN NULL;

Line 223: PER_PEOPLE_F

219: DISTINCT
220: EMPLOYEE_NUMBER
221: INTO V_EMPLOYEE_NUMBER
222: FROM
223: PER_PEOPLE_F
224: WHERE PERSON_ID = PERSON_ID_V
225: AND ( V_TIME_PERIOD_END Between EFFECTIVE_START_DATE
226: AND EFFECTIVE_END_DATE );
227: ELSE

Line 233: PER_PEOPLE_F

229: DISTINCT
230: EMPLOYEE_NUMBER
231: INTO V_EMPLOYEE_NUMBER
232: FROM
233: PER_PEOPLE_F
234: WHERE PERSON_ID = PERSON_ID_V;
235: END IF;
236: RETURN V_EMPLOYEE_NUMBER;
237: RETURN NULL;