APPS.PSP_PSPLDSSA_XMLP_PKG dependencies on PER_ALL_PEOPLE_F
Line 166: PER_ALL_PEOPLE_F
162: DISTINCT
163: FULL_NAME
164: INTO V_PERSON_NAME
165: FROM 166: PER_ALL_PEOPLE_F 167: WHERE PERSON_ID = PERSON_ID_arg
168: AND ( P_TIME_PERIOD_END Between EFFECTIVE_START_DATE
169: AND EFFECTIVE_END_DATE );
170: ELSE
Line 176: PER_ALL_PEOPLE_F
172: DISTINCT
173: FULL_NAME
174: INTO V_PERSON_NAME
175: FROM 176: PER_ALL_PEOPLE_F 177: WHERE PERSON_ID = PERSON_ID_arg;
178: END IF;
179: RETURN V_PERSON_NAME;
180: RETURN NULL;