APPS.PAY_PYAURECP_XMLP_PKG dependencies on PER_ASSIGNMENTS_F

Line 54: PER_ASSIGNMENTS_F PAA

50: CURSOR C_ASSIGNMENT_INFO(C_ASSIGNMENT_ID IN NUMBER) IS
51: SELECT
52: PAA.ASSIGNMENT_NUMBER
53: FROM
54: PER_ASSIGNMENTS_F PAA
55: WHERE PAA.ASSIGNMENT_ID = C_ASSIGNMENT_ID
56: AND PAA.EFFECTIVE_START_DATE = (
57: SELECT
58: MAX(PAA1.EFFECTIVE_START_DATE)

Line 60: PER_ASSIGNMENTS_F PAA1

56: AND PAA.EFFECTIVE_START_DATE = (
57: SELECT
58: MAX(PAA1.EFFECTIVE_START_DATE)
59: FROM
60: PER_ASSIGNMENTS_F PAA1
61: WHERE PAA1.ASSIGNMENT_ID = PAA.ASSIGNMENT_ID
62: AND PAA1.EFFECTIVE_START_DATE <= CP_FIN_YR_END
63: AND PAA1.EFFECTIVE_END_DATE >= CP_FIN_YR_START );
64: CURSOR C_GET_GLOBAL(C_NAME IN VARCHAR2,C_YEAR_END IN DATE) IS