APPS.PAY_PYAURECD_XMLP_PKG dependencies on PER_ASSIGNMENTS_F

Line 318: CURSOR GET_EMP_NAME(C_ASS_ID IN PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE) IS

314: END CF_EMPLOYEE_TYPE_DISPLAYFORMUL;
315:
316: FUNCTION CF_EMP_DISPLAYFORMULA RETURN CHAR IS
317: L_EMP_NAME VARCHAR2(80) := NULL;
318: CURSOR GET_EMP_NAME(C_ASS_ID IN PER_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE) IS
319: SELECT
320: SUBSTR(PPF.FULL_NAME
321: ,1
322: ,80)

Line 325: PER_ASSIGNMENTS_F PAF

321: ,1
322: ,80)
323: FROM
324: PER_PEOPLE_F PPF,
325: PER_ASSIGNMENTS_F PAF
326: WHERE PAF.PERSON_ID = PPF.PERSON_ID
327: AND PAF.ASSIGNMENT_ID = C_ASS_ID;
328: BEGIN
329: IF (LP_ASSIGNMENT_ID IS NOT NULL) THEN