DBA Data[Home] [Help]

APPS.PAY_QPU_API dependencies on PAY_ACTION_INTERLOCKS

Line 88: , pay_action_interlocks ail

84: select /*+ INDEX(ppq PAY_PAYROLL_ACTIONS_PK) */
85: 'Y'
86: from pay_payroll_actions ppq
87: , pay_assignment_actions app
88: , pay_action_interlocks ail
89: , pay_assignment_actions aqr
90: where aqr.payroll_action_id = p_target_payroll_action_id
91: and ail.locked_action_id = aqr.assignment_action_id
92: and app.assignment_action_id = ail.locking_action_id

Line 438: , pay_action_interlocks aci

434: cursor csr_paid is
435: select 'Y'
436: from pay_payroll_actions pac
437: , pay_assignment_actions aac
438: , pay_action_interlocks aci
439: where aci.locked_action_id = p_assignment_action_id
440: and aac.assignment_action_id = aci.locking_action_id
441: and pac.payroll_action_id = aac.payroll_action_id
442: and pac.action_type in ('E', 'H', 'A', 'M');