[Home] [Help]
77: from pay_assignment_actions paa , per_all_assignments_f paf, hr_all_organization_units hou, per_all_people_f ppf
78: where paa.payroll_action_id = p_pact_id
79: and paa.action_status = 'C'
80: and not exists ( select 1
81: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck
82: where lck.locked_action_id = paa.assignment_action_id
83: and lck.locking_action_id = paa1.assignment_action_id
84: and ppa1.payroll_action_id = paa1.payroll_action_id
85: and ppa1.action_type = 'D'
106: from pay_assignment_actions paa , per_all_assignments_f paf, per_all_people_f ppf
107: where paa.payroll_action_id = p_pact_id
108: and paa.action_status = 'C'
109: and not exists ( select 1
110: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck
111: where lck.locked_action_id = paa.assignment_action_id
112: and lck.locking_action_id = paa1.assignment_action_id
113: and ppa1.payroll_action_id = paa1.payroll_action_id
114: and ppa1.action_type = 'D'
133: per_all_people_f ppf, per_all_assignments_f paf
134: where paa.payroll_action_id = p_pact_id
135: and paa.action_status IN ('C','S')
136: and not exists ( select 1
137: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck
138: where lck.locked_action_id = paa.assignment_action_id
139: and lck.locking_action_id = paa1.assignment_action_id
140: and ppa1.payroll_action_id = paa1.payroll_action_id
141: and ppa1.action_type = 'D'
179: FROM pay_pre_payments_v2 pv2
180: WHERE pv2.business_group_id+0 = p_business_group_id
181: AND pv2.assignment_action_id = l_assact_id
182: AND pv2.pre_payment_id in (select ppp.pre_payment_id
183: from pay_pre_payments ppp,pay_action_interlocks lck , pay_org_payment_methods_f org ,
184: pay_payment_types pt,pay_assignment_actions paa1
185: where lck.locking_action_id = l_assact_id
186: and lck.locked_action_id = ppp.assignment_action_id
187: and paa1.assignment_action_id = lck.locking_action_id