DBA Data[Home] [Help]

APPS.PSP_PSPDAREG_XMLP_PKG dependencies on PER_PEOPLE_X

Line 141: PER_PEOPLE_X PPX,

137: SELECT
138: PPX.FULL_NAME
139: INTO V_FULLNAME
140: FROM
141: PER_PEOPLE_X PPX,
142: FND_USER FU
143: WHERE FU.USER_ID = P_APPROVED_BY
144: AND PPX.PERSON_ID = FU.EMPLOYEE_ID;
145: RETURN (V_FULLNAME);

Line 162: PER_PEOPLE_X PPX,

158: SELECT
159: PPX.FULL_NAME
160: INTO V_FULLNAME
161: FROM
162: PER_PEOPLE_X PPX,
163: FND_USER FU
164: WHERE FU.USER_ID = P_SUBMITTED_BY
165: AND PPX.PERSON_ID = FU.EMPLOYEE_ID;
166: RETURN (V_FULLNAME);