[Home] [Help]
435: /* PL/SQL table to take the person and his corresponding payroll runs in the given period .The table consists
436: person id,assignment id and the time period details for that person which it self a PL/SQL table */
437:
438: type per_period_detail_rec is record (
439: person_id per_all_people_f.person_id%type,
440: assignment_id per_all_assignments_f.assignment_id%type,
441: time_period benefit_time_period
442: );
443:
522: ) is
523: select iv1.name, eev1.effective_start_date, eev1.screen_entry_value screen_entry_value, iv1.lookup_type, uom
524: from per_all_assignments_f asg1,
525: per_all_assignments_f asg2,
526: per_all_people_f per,
527: pay_element_links_f el,
528: pay_element_types_f et,
529: pay_input_values_f iv1,
530: pay_element_entries_f ee,
1072: p_effective_date date
1073: ) is
1074: select papf.person_id person_id, paaf.assignment_id, national_identifier, full_name, employee_number,
1075: hourly_salaried_code, paaf.primary_flag, papf.date_of_birth, paaf.job_id, position_id
1076: from per_all_people_f papf, per_all_assignments_f paaf, pay_assignment_actions pac
1077: where pac.assignment_action_id = p_arch_assignment_action_id
1078: and paaf.assignment_id = pac.assignment_id
1079: and paaf.person_id = papf.person_id
1080: and p_effective_date between paaf.effective_start_date and paaf.effective_end_date
1088: ) is
1089: select eev1.screen_entry_value screen_entry_value
1090: from per_all_assignments_f asg1,
1091: per_all_assignments_f asg2,
1092: per_all_people_f per,
1093: pay_element_links_f el,
1094: pay_element_types_f et,
1095: pay_input_values_f iv1,
1096: pay_element_entries_f ee,
1121: ) is
1122: select iv1.name, eev1.effective_start_date, eev1.screen_entry_value screen_entry_value, iv1.lookup_type, uom
1123: from per_all_assignments_f asg1,
1124: per_all_assignments_f asg2,
1125: per_all_people_f per,
1126: pay_element_links_f el,
1127: pay_element_types_f et,
1128: pay_input_values_f iv1,
1129: pay_element_entries_f ee,