[Home] [Help]
178: if asg_rec.assignment_id < nvl(l_stored_asg_id,999999999) THEN
179: l_stored_asg_id := asg_rec.assignment_id;
180: end if;
181: else
182: select pay_assignment_actions_s.nextval
183: into l_locking_act_id
184: from dual;
185:
186: hr_nonrun_asact.insact(l_locking_act_id,
196:
197: if l_stored_asg_id is not null then
198: hr_utility.set_location('Person ID/Assignment ID: '||
199: l_stored_per_id || '/' || l_stored_asg_id,20);
200: select pay_assignment_actions_s.nextval
201: into l_locking_act_id
202: from dual;
203:
204: hr_nonrun_asact.insact(l_locking_act_id,
246: substr(pay_gb_eoy_archive.get_parameter(legislative_parameters,
247: 'TAX_REF'),1,20) tax_ref,
248: effective_date,
249: business_group_id
250: from pay_assignment_actions paa,
251: pay_payroll_actions pay
252: where paa.assignment_action_id = p_assact_id
253: and pay.payroll_action_id = paa.payroll_action_id;
254:
254:
255: cursor csr_person_id is
256: select person_id,
257: paa.assignment_id
258: from pay_assignment_actions paa,
259: per_all_assignments_f paf
260: where paa.assignment_action_id = p_assact_id
261: and paa.assignment_id = paf.assignment_id;
262:
347: pap.last_name,
348: paa.ASSIGNMENT_NUMBER,
349: pap.national_identifier,
350: paa.assignment_id
351: from pay_assignment_actions pact,
352: per_assignments_f paa,
353: per_people_f pap
354: where pact.assignment_action_id = p_assactid
355: and pact.assignment_id = paa.assignment_id
403: aei.aei_information2 not_flag,
404: aei.aei_information3 ni_update,
405: aei.object_version_number,
406: paa.assignment_id
407: from pay_assignment_actions paa,
408: per_assignment_extra_info aei
409: where paa.assignment_action_id = p_assactid
410: and paa.assignment_id = aei.assignment_id
411: and aei.information_type = 'GB_WNU';
806: paf.assignment_number emp_no,
807: peo.national_identifier ni_no ,
808: pai.action_information2 old_works_number
809: from pay_payroll_actions pay,
810: pay_assignment_actions paa,
811: per_all_assignments_f paf,
812: per_all_people_f peo,
813: pay_action_information pai
814: where pay.payroll_action_id = pactid