DBA Data[Home] [Help]

APPS.PSP_PAYTRN dependencies on PAY_ACTION_INTERLOCKS

Line 129: FROM pay_action_interlocks pai1

125: between l_start_date and l_end_date
126: and ppa1.action_type IN ('R','Q','V') -- regular run, quick_pay, reversals
127: and ppa1.payroll_action_id = paa1.payroll_action_id
128: and EXISTS (SELECT /*+ use_nl(PAI1) */ pai1.locked_action_id
129: FROM pay_action_interlocks pai1
130: WHERE paa1.assignment_action_id = pai1.locked_action_id
131: and pai1.locking_action_id = paa2.assignment_action_id) -- End of changes for bug fix 3263333
132: and paa2.payroll_action_id = ppa2.payroll_action_id
133: and ppa2.action_type = 'C'

Line 157: FROM pay_action_interlocks pai1

153: and ppa1.action_type='C' and
154: ppa1.action_status='C'
155: and ppa1.payroll_action_id=paa1.payroll_action_id
156: and EXISTS (SELECT /*+ use_nl(PAI1) */ pai1.locked_action_id
157: FROM pay_action_interlocks pai1
158: WHERE paa1.assignment_action_id=pai1.locking_action_id
159: and pai1.locked_action_id = paa2.assignment_action_id) -- End of changes for bug fix 3263333
160: and paa2.payroll_action_id = ppa2.payroll_action_id
161: and ppa2.action_type not in ('R','Q' ,'F','V')

Line 183: FROM pay_action_interlocks pai1

179: and ppa1.action_type='C' and
180: ppa1.action_status='C'
181: and ppa1.payroll_action_id=paa1.payroll_action_id
182: and EXISTS (SELECT /*+ use_nl(PAI1) */ pai1.locked_action_id
183: FROM pay_action_interlocks pai1
184: WHERE paa1.assignment_action_id=pai1.locking_action_id
185: and pai1.locked_action_id = paa2.assignment_action_id) -- End of changes for bug fix 3263333
186: and paa2.payroll_action_id = ppa2.payroll_action_id
187: and ppa2.action_type not in ('R','Q' ,'F','V')