DBA Data[Home] [Help]

APPS.PAY_PAYGBTPL_XMLP_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 198: PAY_ASSIGNMENT_ACTIONS ASSACT2,

194: ,15
195: ,'0') || R2.SOURCE_TYPE || R2.RUN_RESULT_ID)
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

Line 222: PAY_ASSIGNMENT_ACTIONS ASSACT3,

218: SELECT
219: '1'
220: FROM
221: PAY_ACTION_INTERLOCKS PAI,
222: PAY_ASSIGNMENT_ACTIONS ASSACT3,
223: PAY_PAYROLL_ACTIONS PACT3
224: WHERE PAI.LOCKED_ACTION_ID = ASSACT2.ASSIGNMENT_ACTION_ID
225: AND PAI.LOCKING_ACTION_ID = ASSACT3.ASSIGNMENT_ACTION_ID
226: AND PACT3.PAYROLL_ACTION_ID = ASSACT3.PAYROLL_ACTION_ID

Line 318: PAY_ASSIGNMENT_ACTIONS PAA

314: PPA.TIME_PERIOD_ID
315: INTO L_ACTION_EFFECTIVE,L_TIME_PERIOD_ID
316: FROM
317: PAY_PAYROLL_ACTIONS PPA,
318: PAY_ASSIGNMENT_ACTIONS PAA
319: WHERE PAA.ASSIGNMENT_ACTION_ID = ASG_ACTION_ID
320: AND PPA.PAYROLL_ACTION_ID = PAA.PAYROLL_ACTION_ID;
321: SELECT
322: PTP.START_DATE,