[Home] [Help]
605:
606: -- Archive the payroll action level data and EIT defintions.
607: -- sql string to SELECT a range of assignments eligible for archival.
608: p_sql := ' select distinct p.person_id' ||
609: ' from per_people_f p,' ||
610: ' pay_payroll_actions pa' ||
611: ' where pa.payroll_action_id = :payroll_action_id' ||
612: ' and p.business_group_id = pa.business_group_id' ||
613: ' order by p.person_id';
711: select distinct per_information2, paa.tax_unit_id,
712: assignment_action_id assignment_action_id
713: from pay_payroll_actions ppa,
714: pay_assignment_actions paa,
715: per_people_f pap,
716: per_assignments_f paf
717: where paa.payroll_action_id = ppa.payroll_action_id
718: and pap.person_id = paf.person_id
719: and paa.assignment_id = paf.assignment_id
882: paaf.assignment_id,
883: paa.tax_unit_id,
884: paa.source_action_id master_action_id,
885: paa2.tax_unit_id master_tax_unit_id
886: from per_people_f pap,
887: per_assignments_f paaf,
888: pay_payroll_actions ppa,
889: pay_payroll_actions ppa1,
890: pay_assignment_actions paa,
1073: /* 5893671*/
1074: cursor c_get_employee_full_name (c_person_id number, c_end_date date, c_start_date date)
1075: is
1076: select full_name
1077: from per_people_f pap
1078: where person_id= c_person_id
1079: and pap.effective_end_date =
1080: (select max(effective_end_date)
1081: from per_people_f pap1
1077: from per_people_f pap
1078: where person_id= c_person_id
1079: and pap.effective_end_date =
1080: (select max(effective_end_date)
1081: from per_people_f pap1
1082: where pap1.person_id = pap.person_id
1083: and pap1.effective_end_date >= c_start_date
1084: and pap1.effective_start_date <= c_end_date
1085: );
1114:
1115: hoi.org_information2 dge_legal_employer,
1116: hoi.org_information3 dge_group_name,
1117: hl.meaning state_desc
1118: from per_people_f pap,
1119: per_assignments_f paaf,
1120: pay_payroll_actions ppa,
1121: pay_payroll_actions ppa1,
1122: pay_assignment_actions paa,