[Home] [Help]
688:
689: Cursor c_get_ds_code is
690: select dut.duty_station_code
691: from hr_location_extra_info lei,
692: per_all_assignments_f asg,
693: ghr_duty_stations_v dut
694: where asg.assignment_id = l_assignment_id
695: and l_effective_date between
696: asg.effective_Start_date and asg.effective_end_date
2062: p_agency_code IN varchar2,
2063: p_agency_sub_code IN varchar2) IS
2064:
2065: l_assignment_id pay_element_entries_f.assignment_id%type;
2066: l_position_id per_all_assignments_f.position_id%type;
2067: l_person_id per_all_assignments_f.person_id%type;
2068: l_agncy_contrib_elig_date per_people_extra_info.pei_information14%type;
2069: l_effective_start_date per_all_people_f.effective_start_date%type;
2070: l_effective_end_date per_all_people_f.effective_end_date%type;
2063: p_agency_sub_code IN varchar2) IS
2064:
2065: l_assignment_id pay_element_entries_f.assignment_id%type;
2066: l_position_id per_all_assignments_f.position_id%type;
2067: l_person_id per_all_assignments_f.person_id%type;
2068: l_agncy_contrib_elig_date per_people_extra_info.pei_information14%type;
2069: l_effective_start_date per_all_people_f.effective_start_date%type;
2070: l_effective_end_date per_all_people_f.effective_end_date%type;
2071: l_retirement_plan pay_element_entry_values_f.screen_entry_value%type;
2108: CURSOR c_tsp_agncy_date IS
2109: select paf.position_id,ppf.person_id,paf.assignment_id,
2110: ppei.pei_information14 ,ppf.effective_start_date, ppf.effective_end_date,ppf.national_identifier,
2111: ppf.full_name,ppf.employee_number
2112: from per_all_people_f ppf, per_all_assignments_f paf, per_people_extra_info ppei
2113: where ppf.person_id=paf.person_id
2114: and ppf.person_id=ppei.person_id
2115: and ppei.information_type='GHR_US_PER_BENEFIT_INFO'
2116: and paf.primary_flag='Y'