DBA Data[Home] [Help]

APPS.PAY_PAYJPITT_XMLP_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 142: PAY_ACTION_INTERLOCKS PAI

138: AND NOT EXISTS(
139: SELECT NULL
140: FROM PAY_PAYROLL_ACTIONS PPAV,
141: PAY_ASSIGNMENT_ACTIONS PAAV,
142: PAY_ACTION_INTERLOCKS PAI
143: WHERE PAI.LOCKED_ACTION_ID = PAA.ASSIGNMENT_ACTION_ID
144: AND PAAV.ASSIGNMENT_ACTION_ID = PAI.LOCKING_ACTION_ID
145: AND PPAV.PAYROLL_ACTION_ID = PAAV.PAYROLL_ACTION_ID
146: AND PPAV.ACTION_TYPE = 'V');