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

Line 302: , PER_ASSIGNMENTS_F PAF

298: IS
299: SELECT TO_NUMBER(SUBSTR(MAX(LPAD(PAA.ACTION_SEQUENCE,15,'0')||PAA.ASSIGNMENT_ACTION_ID),16)) ASSIGNMENT_ACTION_ID
300: FROM PAY_ASSIGNMENT_ACTIONS PAA
301: , PAY_PAYROLL_ACTIONS PPA
302: , PER_ASSIGNMENTS_F PAF
303: WHERE PAA.ASSIGNMENT_ID = PAF.ASSIGNMENT_ID
304: AND PAF.ASSIGNMENT_ID = C_ASSIGNMENT_ID
305: AND PAA.ASSIGNMENT_ID = C_ASSIGNMENT_ID
306: AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID