[Home] [Help]
124: substr(trim(pap.last_name), 1,35) last_name,
125: substr(trim(pap.first_name), 1,least(decode(instr(trim(pap.first_name),' '),0,35,instr(trim(pap.first_name),' ')),35)) first_name,
126: substr(pap.national_identifier,1,9) national_identifier,
127: pap.effective_start_date effective_start_date
128: FROM pay_assignment_actions act,
129: per_all_assignments_f paa,
130: per_all_people_f pap
131: where act.assignment_action_id = p_assactid
132: and act.assignment_id = paa.assignment_id
323: pay_element_entries_f peef,
324: per_all_assignments_f paaf,
325: hr_soft_coding_keyflex sc,
326: pay_all_payrolls_f ppf,
327: pay_assignment_actions paa,
328: pay_payroll_actions ppa
329: where pet.element_name in ('Court Order','Court Order NTPP')
330: AND pet.business_group_id IS NULL
331: AND pet.legislation_code = 'GB'
389: --hr_utility.set_location('Assignment ID :' || asg_rec.date_paid,15);
390:
391: -- Create one assignment action for every assignment
392: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);
393: select pay_assignment_actions_s.nextval
394: into lockingactid
395: from dual;
396:
397: -- Insert assignment into pay_assignment_actions
393: select pay_assignment_actions_s.nextval
394: into lockingactid
395: from dual;
396:
397: -- Insert assignment into pay_assignment_actions
398: hr_nonrun_asact.insact
399: (
400: lockingactid,
401: asg_rec.assignment_id,
461: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYMENT_FROM'),1,10)) payment_from_date,
462: fnd_date.canonical_to_date(SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'PAYMENT_TO'),1,10)) payment_to_date,
463: business_group_id
464: from pay_payroll_actions pact,
465: pay_assignment_actions paa
466: where paa.assignment_action_id = p_assactid
467: and paa.payroll_action_id = pact.payroll_action_id;
468:
469:
478: pay_element_entries_f peef,
479: per_all_assignments_f paaf,
480: hr_soft_coding_keyflex scl,
481: pay_all_payrolls_f ppf,
482: pay_assignment_actions paa,
483: pay_payroll_actions ppa
484: where pet1.element_name in ('Court Order','Court Order NTPP')
485: AND pet1.business_group_id IS NULL
486: AND pet1.legislation_code = 'GB'
549: pay_element_entries_f peef,
550: per_all_assignments_f paaf,
551: hr_soft_coding_keyflex sc,
552: pay_all_payrolls_f ppf,
553: pay_assignment_actions paa,
554: pay_payroll_actions ppa
555: where pet.element_name in ('Court Order','Court Order NTPP')
556: AND pet.business_group_id IS NULL
557: AND pet.legislation_code = 'GB'
946: cursor get_asg_action_id is
947: select distinct paa.assignment_action_id asg_action_id, paa.assignment_id
948: , paaf.assignment_number
949: from pay_payroll_actions ppa,
950: pay_assignment_actions paa
951: , per_all_assignments_f paaf
952: where ppa.payroll_action_id = pactid -- pact_id
953: and paa.payroll_action_id = ppa.payroll_action_id
954: and paa.action_status = 'C'
968: pai_emp.action_information4 l_name,
969: nvl(pai_emp.action_information5,' ')ni_no,
970: nvl(pai_emp.action_information6,' ')emp_no
971: from pay_action_information pai_emp,
972: pay_assignment_actions paa
973: where paa.payroll_action_id = pactid and paa.ACTION_STATUS = 'C' and paa.assignment_id = c_assignment_id
974: and pai_emp.action_context_id = paa.assignment_action_id
975: and pai_emp.action_information_category = 'GB DEO EMPLOYEE DETAILS';
976:
1012:
1013: cursor get_person_count is
1014: select count(distinct(paaf.person_id))
1015: from pay_payroll_actions ppa,
1016: pay_assignment_actions paa,
1017: per_all_assignments_f paaf
1018: where ppa.payroll_action_id = pactid -- pact_id
1019: and paa.payroll_action_id = ppa.payroll_action_id
1020: and paa.action_status = 'C'