APPS.PSP_PAYTRN dependencies on PAY_ACTION_INTERLOCKS

Line 127: FROM pay_action_interlocks pai1

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

Line 155: FROM pay_action_interlocks pai1

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

Line 181: FROM pay_action_interlocks pai1

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