[Home] [Help]
173: if asg_rec.assignment_id < nvl(l_stored_asg_id,999999999) THEN
174: l_stored_asg_id := asg_rec.assignment_id;
175: end if;
176: else
177: select pay_assignment_actions_s.nextval
178: into l_locking_act_id
179: from dual;
180:
181: hr_nonrun_asact.insact(l_locking_act_id,
191:
192: if l_stored_asg_id is not null then
193: hr_utility.set_location('Person ID/Assignment ID: '||
194: l_stored_per_id || '/' || l_stored_asg_id,20);
195: select pay_assignment_actions_s.nextval
196: into l_locking_act_id
197: from dual;
198:
199: hr_nonrun_asact.insact(l_locking_act_id,
241: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
242: 'TAX_REF'),1,20) tax_ref,
243: effective_date,
244: business_group_id
245: from pay_assignment_actions paa,
246: pay_payroll_actions pay
247: where paa.assignment_action_id = p_assact_id
248: and pay.payroll_action_id = paa.payroll_action_id;
249:
249:
250: cursor csr_person_id is
251: select person_id,
252: paa.assignment_id
253: from pay_assignment_actions paa,
254: per_all_assignments_f paf
255: where paa.assignment_action_id = p_assact_id
256: and paa.assignment_id = paf.assignment_id;
257:
342: pap.last_name,
343: paa.ASSIGNMENT_NUMBER,
344: pap.national_identifier,
345: paa.assignment_id
346: from pay_assignment_actions pact,
347: per_assignments_f paa,
348: per_people_f pap
349: where pact.assignment_action_id = p_assactid
350: and pact.assignment_id = paa.assignment_id
398: aei.aei_information2 not_flag,
399: aei.aei_information3 ni_update,
400: aei.object_version_number,
401: paa.assignment_id
402: from pay_assignment_actions paa,
403: per_assignment_extra_info aei
404: where paa.assignment_action_id = p_assactid
405: and paa.assignment_id = aei.assignment_id
406: and aei.information_type = 'GB_WNU';
789: paf.assignment_number emp_no,
790: peo.national_identifier ni_no ,
791: pai.action_information2 old_works_number
792: from pay_payroll_actions pay,
793: pay_assignment_actions paa,
794: per_all_assignments_f paf,
795: per_all_people_f peo,
796: pay_action_information pai
797: where pay.payroll_action_id = pactid