DBA Data[Home] [Help]

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