[Home] [Help]
116: -- This function now uses the PAY_CC_PROCESS_UTILS.get_asg_act_status
117: -- function to derive its value.
118: -- --
119: -- -- A given assignment action is void if there is a payroll action of type 'D'
120: -- -- locks ( though PAY_ACTION_INTERLOCKS ) the assignment action.
121: -- -- Note that this cursor does not check whether the void assignment action has
122: -- -- a status of complete
123: -- --
124: -- cursor c_is_voided ( p_assignment_action_id in number ) is
123: -- --
124: -- cursor c_is_voided ( p_assignment_action_id in number ) is
125: -- select intloc.locking_action_id
126: -- from pay_assignment_actions assact,
127: -- pay_action_interlocks intloc,
128: -- pay_payroll_actions pact
129: -- where intloc.locked_action_id = p_assignment_action_id
130: -- and intloc.locking_action_id = assact.assignment_action_id
131: -- and assact.payroll_action_id = pact.payroll_action_id
147: -- and ppe.status <> 'C'
148: -- )
149: -- and not exists (select ''
150: -- from pay_assignment_actions paa1, -- Prepay/Costing
151: -- pay_action_interlocks pai1,
152: -- pay_assignment_actions paa2,-- Payment/Trans GL
153: -- pay_action_interlocks pai2
154: -- where pai1.locked_action_id = paa.assignment_action_id
155: -- and pai1.locking_action_id = paa1.assignment_action_id
149: -- and not exists (select ''
150: -- from pay_assignment_actions paa1, -- Prepay/Costing
151: -- pay_action_interlocks pai1,
152: -- pay_assignment_actions paa2,-- Payment/Trans GL
153: -- pay_action_interlocks pai2
154: -- where pai1.locked_action_id = paa.assignment_action_id
155: -- and pai1.locking_action_id = paa1.assignment_action_id
156: -- and pai2.locked_action_id = paa1.assignment_action_id
157: -- and pai2.locking_action_id = paa2.assignment_action_id);
165: -- and paa.payroll_action_id = ppa.payroll_action_id
166: -- and paa.action_status = 'C'
167: -- and not exists (select ''
168: -- from pay_assignment_actions paa1, -- Payment/Trans GL
169: -- pay_action_interlocks pai1
170: -- where pai1.locked_action_id = paa.assignment_action_id
171: -- and pai1.locking_action_id = paa1.assignment_action_id)
172: -- and (exists (select ''
173: -- from pay_process_events ppe
177: -- and ppe.status <> 'C'
178: -- )
179: -- or
180: -- exists (select ''
181: -- from pay_action_interlocks pai,
182: -- pay_assignment_actions paa2,
183: -- pay_payroll_actions ppa2
184: -- where pai.locking_action_id = paa.assignment_action_id
185: -- and pai.locked_action_id = paa2.assignment_action_id
204: -- and paa.payroll_action_id = ppa.payroll_action_id
205: -- and paa.action_status = 'C'
206: -- and not exists (select ''
207: -- from pay_assignment_actions paa1, -- Payment/Trans GL
208: -- pay_action_interlocks pai1
209: -- where pai1.locked_action_id = paa.assignment_action_id
210: -- and pai1.locking_action_id = paa1.assignment_action_id)
211: -- and exists (select ''
212: -- from pay_process_events ppe
215: -- and ppe.change_type in ('COST_CENTRE')
216: -- and ppe.status <> 'C'
217: -- )
218: -- and exists (select ''
219: -- from pay_action_interlocks pai,
220: -- pay_assignment_actions paa2,
221: -- pay_payroll_actions ppa2
222: -- where pai.locking_action_id = paa.assignment_action_id
223: -- and pai.locked_action_id = paa2.assignment_action_id
344: aac.action_status,
345: pac.action_type
346: from pay_payroll_actions pac,
347: pay_assignment_actions aac,
348: pay_action_interlocks loc
349: where loc.locked_action_id = p_assignment_action_id
350: and loc.locking_action_id = aac.assignment_action_id
351: and aac.pre_payment_id = p_pre_payment_id
352: and aac.action_status = 'C'
359: cursor get_locking_void_action ( p_assignment_action_id number ) is
360: select aac.assignment_action_id
361: from pay_payroll_actions pac,
362: pay_assignment_actions aac,
363: pay_action_interlocks loc
364: where loc.locked_action_id = p_assignment_action_id
365: and loc.locking_action_id = aac.assignment_action_id
366: and aac.payroll_action_id = pac.payroll_action_id
367: and pac.action_type = 'D' ;