[Home] [Help]
130: paf.assignment_id,
131: paf.person_id,
132: paa.tax_unit_id,
133: paf.location_id
134: FROM pay_assignment_actions paa,
135: pay_payroll_actions ppa,
136: per_assignments_f paf,
137: per_jobs pj,
138: per_gen_hierarchy_nodes pghn,
147: AND paa.action_sequence IN (
148: SELECT MAX(paa2.action_sequence)
149: FROM pay_action_classifications pac,
150: pay_payroll_actions ppa2,
151: pay_assignment_actions paa2,
152: per_assignments_f paf1
153: WHERE paf1.person_id = paf.person_id
154: AND paa2.assignment_id = paf1.assignment_id
155: AND paf1.primary_flag = 'Y' -- BUG3941460
264:
265: hr_utility.set_location(l_package||':stperson:'||stperson,40);
266: --Get the assignment_action_id for creating one for each selected asact_id
267:
268: SELECT pay_assignment_actions_s.nextval
269: INTO lockingactid
270: FROM dual;
271:
272:
276: hr_utility.trace('l_asgnid = '||to_char(l_asgnid));
277: hr_utility.trace('l_person_id = '||to_char(l_person_id));
278:
279: hr_nonrun_asact.insact(lockingactid,l_asgnid,pactid,chunk,l_gre_id);
280: UPDATE pay_assignment_actions
281: SET serial_number = l_person_id,
282: source_action_id = l_location_id
283: WHERE assignment_action_id = lockingactid;
284:
282: source_action_id = l_location_id
283: WHERE assignment_action_id = lockingactid;
284:
285: hr_utility.set_location(l_package||':stperson:'||stperson,60);
286: hr_utility.trace('After inserting into pay_assignment_actions, before pay_action_interlock');
287: -- insert an interlock to this action.
288:
289: hr_nonrun_asact.insint(lockingactid,lockedactid);
290: hr_utility.trace('loop ends');
307: ) is
308: BEGIN
309: sqlstr :=
310: 'select paa.rowid
311: from pay_assignment_actions paa /* PYUGEN assignment action */
312: where paa.payroll_action_id = :payactid
313: for update of paa.assignment_id';
314:
315: len := length(sqlstr); -- return the length of the string.