DBA Data[Home] [Help]

APPS.PAY_PYAURECP_XMLP_PKG dependencies on PER_ASSIGNMENT_EXTRA_INFO

Line 283: FROM PER_ASSIGNMENT_EXTRA_INFO PAE,

279: C_FIN_DATE IN DATE,
280: C_TAX_UNIT_ID IN PAY_ASSIGNMENT_ACTIONS.TAX_UNIT_ID%TYPE)
281: IS
282: SELECT HR.MEANING FIN_YEAR
283: FROM PER_ASSIGNMENT_EXTRA_INFO PAE,
284: HR_LOOKUPS HR
285: WHERE PAE.AEI_INFORMATION_CATEGORY = 'HR_PS_ISSUE_DATE_AU'
286: AND PAE.INFORMATION_TYPE = 'HR_PS_ISSUE_DATE_AU'
287: AND PAE.ASSIGNMENT_ID = C_ASSIGNMENT_ID