APPS.PAY_PYAURECP_XMLP_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO
Line 265: PER_ASSIGNMENT_EXTRA_INFO PAE,
261: CURSOR C_PAYMENT_SUMMARY_DETAILS(C_ASSIGNMENT_ID IN NUMBER,C_FIN_DATE IN DATE,C_TAX_UNIT_ID IN PAY_ASSIGNMENT_ACTIONS.TAX_UNIT_ID%TYPE) IS
262: SELECT
263: HR.MEANING FIN_YEAR
264: FROM 265: PER_ASSIGNMENT_EXTRA_INFO PAE, 266: HR_LOOKUPS HR
267: WHERE PAE.AEI_INFORMATION_CATEGORY = 'HR_PS_ISSUE_DATE_AU'
268: AND PAE.INFORMATION_TYPE = 'HR_PS_ISSUE_DATE_AU'
269: AND PAE.ASSIGNMENT_ID = C_ASSIGNMENT_ID