APPS.GHR_DS_JAN99_PKG dependencies on PER_PEOPLE_F

Line 17: l_person_id per_people_f.person_id%TYPE;

13: l_new_duty_station_code ghr_duty_stations_f.duty_station_code%TYPE;
14: l_old_locality_pay_area_id ghr_duty_stations_f.locality_pay_area_id%TYPE;
15: l_new_locality_pay_area_id ghr_duty_stations_f.locality_pay_area_id%TYPE;
16: l_duty_station_code ghr_duty_stations_f.duty_station_code%TYPE;
17: l_person_id per_people_f.person_id%TYPE;
18: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
19: l_full_name per_people_f.full_name%TYPE;
20: l_national_identifier per_people_f.national_identifier%TYPE;
21: l_assignment_id per_assignments_f.assignment_id%TYPE;

Line 19: l_full_name per_people_f.full_name%TYPE;

15: l_new_locality_pay_area_id ghr_duty_stations_f.locality_pay_area_id%TYPE;
16: l_duty_station_code ghr_duty_stations_f.duty_station_code%TYPE;
17: l_person_id per_people_f.person_id%TYPE;
18: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
19: l_full_name per_people_f.full_name%TYPE;
20: l_national_identifier per_people_f.national_identifier%TYPE;
21: l_assignment_id per_assignments_f.assignment_id%TYPE;
22: l_location_id per_assignments_f.location_id%TYPE;
23: l_position_id per_assignments_f.position_id%TYPE;

Line 20: l_national_identifier per_people_f.national_identifier%TYPE;

16: l_duty_station_code ghr_duty_stations_f.duty_station_code%TYPE;
17: l_person_id per_people_f.person_id%TYPE;
18: l_effective_start_date per_assignments_f.effective_start_date%TYPE;
19: l_full_name per_people_f.full_name%TYPE;
20: l_national_identifier per_people_f.national_identifier%TYPE;
21: l_assignment_id per_assignments_f.assignment_id%TYPE;
22: l_location_id per_assignments_f.location_id%TYPE;
23: l_position_id per_assignments_f.position_id%TYPE;
24: l_pos_name per_positions.name%TYPE;

Line 147: from per_people_f ppf

143:
144:
145: Cursor c_full_name is
146: select ppf.full_name
147: from per_people_f ppf
148: where person_id = l_person_id
149: and l_effective_date
150: between ppf.effective_start_date and ppf.effective_end_date;
151: