DBA Data[Home] [Help]

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;