DBA Data[Home] [Help]

APPS.PAY_PAYGBTPL_XMLP_PKG dependencies on PAY_RUN_RESULTS

Line 200: PAY_RUN_RESULTS R2

196: ,17))
197: FROM
198: PAY_ASSIGNMENT_ACTIONS ASSACT2,
199: PAY_PAYROLL_ACTIONS PACT,
200: PAY_RUN_RESULTS R2
201: WHERE ASSACT2.ASSIGNMENT_ID = L_ASSIGNMENT_ID
202: AND R2.ELEMENT_TYPE_ID + 0 = L_PAYE_ELEMENT_ID
203: AND R2.ASSIGNMENT_ACTION_ID = ASSACT2.ASSIGNMENT_ACTION_ID
204: AND R2.STATUS IN ( 'P' , 'PA' )