8: duty_station_desc ghr_duty_stations_v.duty_station_desc%type
9: );
10:
11: type emp_rec_type is record
12: (person_id per_people_f.person_id%type,
13: first_name per_people_f.first_name%type,
14: last_name per_people_f.last_name%type,
15: middle_names per_people_f.middle_names%type,
16: date_of_birth per_people_f.date_of_birth%type,
9: );
10:
11: type emp_rec_type is record
12: (person_id per_people_f.person_id%type,
13: first_name per_people_f.first_name%type,
14: last_name per_people_f.last_name%type,
15: middle_names per_people_f.middle_names%type,
16: date_of_birth per_people_f.date_of_birth%type,
17: national_identifier per_people_f.national_identifier%type,
10:
11: type emp_rec_type is record
12: (person_id per_people_f.person_id%type,
13: first_name per_people_f.first_name%type,
14: last_name per_people_f.last_name%type,
15: middle_names per_people_f.middle_names%type,
16: date_of_birth per_people_f.date_of_birth%type,
17: national_identifier per_people_f.national_identifier%type,
18: assignment_id per_assignments_f.assignment_id%type
11: type emp_rec_type is record
12: (person_id per_people_f.person_id%type,
13: first_name per_people_f.first_name%type,
14: last_name per_people_f.last_name%type,
15: middle_names per_people_f.middle_names%type,
16: date_of_birth per_people_f.date_of_birth%type,
17: national_identifier per_people_f.national_identifier%type,
18: assignment_id per_assignments_f.assignment_id%type
19: );
12: (person_id per_people_f.person_id%type,
13: first_name per_people_f.first_name%type,
14: last_name per_people_f.last_name%type,
15: middle_names per_people_f.middle_names%type,
16: date_of_birth per_people_f.date_of_birth%type,
17: national_identifier per_people_f.national_identifier%type,
18: assignment_id per_assignments_f.assignment_id%type
19: );
20:
13: first_name per_people_f.first_name%type,
14: last_name per_people_f.last_name%type,
15: middle_names per_people_f.middle_names%type,
16: date_of_birth per_people_f.date_of_birth%type,
17: national_identifier per_people_f.national_identifier%type,
18: assignment_id per_assignments_f.assignment_id%type
19: );
20:
21: procedure get_noa_id_desc