DBA Data[Home] [Help]

APPS.PAY_PAYIEP30_XMLP_PKG dependencies on PAY_ACTION_INTERLOCKS

Line 9: PAY_ACTION_INTERLOCKS PAI_P30,

5: SELECT
6: MIN(PPA_ARC.START_DATE) START_DATE
7: FROM
8: PAY_ASSIGNMENT_ACTIONS PAA_P30,
9: PAY_ACTION_INTERLOCKS PAI_P30,
10: PAY_ASSIGNMENT_ACTIONS PAA_ARC,
11: PAY_PAYROLL_ACTIONS PPA_ARC
12: WHERE PAA_P30.PAYROLL_ACTION_ID = VP_PAYROLL_ACTION_ID
13: AND PAA_P30.ASSIGNMENT_ACTION_ID = PAI_P30.LOCKING_ACTION_ID

Line 155: PAY_ACTION_INTERLOCKS PAI_P30,

151: SELECT
152: PACT_YTDBAL.ACTION_INFORMATION4 BALANCE_VALUE
153: FROM
154: PAY_ASSIGNMENT_ACTIONS PAA_P30,
155: PAY_ACTION_INTERLOCKS PAI_P30,
156: PAY_ASSIGNMENT_ACTIONS PAA_ARC,
157: PAY_ACTION_INFORMATION PACT_YTDBAL,
158: PAY_DEFINED_BALANCES PDB_YTDBAL,
159: PAY_BALANCE_TYPES PBT_YTDBAL,

Line 229: PAY_ACTION_INTERLOCKS PAI_P30,

225: ,'0') || PACT_YTDBAL.ACTION_CONTEXT_ID)
226: ,16))
227: FROM
228: PAY_ASSIGNMENT_ACTIONS PAA_P30,
229: PAY_ACTION_INTERLOCKS PAI_P30,
230: PAY_ASSIGNMENT_ACTIONS PAA_ARC,
231: PAY_ACTION_INFORMATION PACT_YTDBAL,
232: PAY_ACTION_INTERLOCKS PAI_ARC,
233: PAY_ASSIGNMENT_ACTIONS PAA_RUN,

Line 232: PAY_ACTION_INTERLOCKS PAI_ARC,

228: PAY_ASSIGNMENT_ACTIONS PAA_P30,
229: PAY_ACTION_INTERLOCKS PAI_P30,
230: PAY_ASSIGNMENT_ACTIONS PAA_ARC,
231: PAY_ACTION_INFORMATION PACT_YTDBAL,
232: PAY_ACTION_INTERLOCKS PAI_ARC,
233: PAY_ASSIGNMENT_ACTIONS PAA_RUN,
234: PAY_PAYROLL_ACTIONS PPA_RUN
235: WHERE PAA_P30.PAYROLL_ACTION_ID = VP_PAYROLL_ACTION_ID
236: AND PAA_P30.ASSIGNMENT_ID = VP_ASSIGNMENT_ID