[Home] [Help]
307:
308: -- Archive the payroll action level data and EIT defintions.
309: -- sql string to SELECT a range of assignments eligible for archival.
310: p_sql := ' select distinct p.person_id' ||
311: ' from per_people_f p,' ||
312: ' pay_payroll_actions pa' ||
313: ' where pa.payroll_action_id = :payroll_action_id' ||
314: ' and p.business_group_id = pa.business_group_id' ||
315: ' order by p.person_id';
413: select distinct per_information2, paa.tax_unit_id,
414: assignment_action_id assignment_action_id
415: from pay_payroll_actions ppa,
416: pay_assignment_actions paa,
417: per_people_f pap,
418: per_assignments_f paf
419: where paa.payroll_action_id = ppa.payroll_action_id
420: and pap.person_id = paf.person_id
421: and paa.assignment_id = paf.assignment_id
581: paaf.assignment_id,
582: paa.tax_unit_id,
583: paa.source_action_id master_action_id,
584: paa2.tax_unit_id master_tax_unit_id
585: from per_people_f pap,
586: per_assignments_f paaf,
587: pay_payroll_actions ppa,
588: pay_payroll_actions ppa1,
589: pay_assignment_actions paa,
772: /* 5893671*/
773: cursor c_get_employee_full_name (c_person_id number, c_end_date date, c_start_date date)
774: is
775: select full_name
776: from per_people_f pap
777: where person_id= c_person_id
778: and pap.effective_end_date =
779: (select max(effective_end_date)
780: from per_people_f pap1
776: from per_people_f pap
777: where person_id= c_person_id
778: and pap.effective_end_date =
779: (select max(effective_end_date)
780: from per_people_f pap1
781: where pap1.person_id = pap.person_id
782: and pap1.effective_end_date >= c_start_date
783: and pap1.effective_start_date <= c_end_date
784: );
813:
814: hoi.org_information2 dge_legal_employer,
815: hoi.org_information3 dge_group_name,
816: hl.meaning state_desc
817: from per_people_f pap,
818: per_assignments_f paaf,
819: pay_payroll_actions ppa,
820: pay_payroll_actions ppa1,
821: pay_assignment_actions paa,