[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'
102: from pay_assignment_actions paa , per_all_assignments_f paf, per_all_people_f ppf
103: where paa.payroll_action_id = p_pact_id
104: and paa.action_status = 'C'
105: and not exists ( select 1
106: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck
107: where lck.locked_action_id = paa.assignment_action_id
108: and lck.locking_action_id = paa1.assignment_action_id
109: and ppa1.payroll_action_id = paa1.payroll_action_id
110: and ppa1.action_type = 'D'
125: per_all_people_f ppf, per_all_assignments_f paf
126: where paa.payroll_action_id = p_pact_id
127: and paa.action_status = 'C'
128: and not exists ( select 1
129: from pay_assignment_actions paa1, pay_payroll_actions ppa1, pay_action_interlocks lck
130: where lck.locked_action_id = paa.assignment_action_id
131: and lck.locking_action_id = paa1.assignment_action_id
132: and ppa1.payroll_action_id = paa1.payroll_action_id
133: and ppa1.action_type = 'D'
163: FROM pay_pre_payments_v2 pv2
164: WHERE pv2.business_group_id+0 = p_business_group_id
165: AND pv2.assignment_action_id = l_assact_id
166: AND pv2.pre_payment_id in (select ppp.pre_payment_id
167: from pay_pre_payments ppp,pay_action_interlocks lck , pay_org_payment_methods_f org ,
168: pay_payment_types pt,pay_assignment_actions paa1
169: where lck.locking_action_id = l_assact_id
170: and lck.locked_action_id = ppp.assignment_action_id
171: and paa1.assignment_action_id = lck.locking_action_id