APPS.GHR_PA_REQUESTS_PKG dependencies on GHR_DUTY_STATIONS_V

Line 159: PROCEDURE get_duty_station_details (p_duty_station_id IN ghr_duty_stations_v.duty_station_id%TYPE

155: ,p_last_name IN OUT NOCOPY per_people_f.last_name%TYPE
156: ,p_first_name IN OUT NOCOPY per_people_f.first_name%TYPE
157: ,p_middle_names IN OUT NOCOPY per_people_f.middle_names%TYPE);
158: --
159: PROCEDURE get_duty_station_details (p_duty_station_id IN ghr_duty_stations_v.duty_station_id%TYPE
160: ,p_effective_date IN DATE
161: ,p_duty_station_code IN OUT NOCOPY ghr_duty_stations_v.duty_station_code%TYPE
162: ,p_duty_station_desc IN OUT NOCOPY ghr_duty_stations_v.duty_station_desc%TYPE);
163: --

Line 161: ,p_duty_station_code IN OUT NOCOPY ghr_duty_stations_v.duty_station_code%TYPE

157: ,p_middle_names IN OUT NOCOPY per_people_f.middle_names%TYPE);
158: --
159: PROCEDURE get_duty_station_details (p_duty_station_id IN ghr_duty_stations_v.duty_station_id%TYPE
160: ,p_effective_date IN DATE
161: ,p_duty_station_code IN OUT NOCOPY ghr_duty_stations_v.duty_station_code%TYPE
162: ,p_duty_station_desc IN OUT NOCOPY ghr_duty_stations_v.duty_station_desc%TYPE);
163: --
164: PROCEDURE get_SF52_person_ddf_details (p_person_id IN per_people_f.person_id%TYPE
165: ,p_date_effective IN date default sysdate

Line 162: ,p_duty_station_desc IN OUT NOCOPY ghr_duty_stations_v.duty_station_desc%TYPE);

158: --
159: PROCEDURE get_duty_station_details (p_duty_station_id IN ghr_duty_stations_v.duty_station_id%TYPE
160: ,p_effective_date IN DATE
161: ,p_duty_station_code IN OUT NOCOPY ghr_duty_stations_v.duty_station_code%TYPE
162: ,p_duty_station_desc IN OUT NOCOPY ghr_duty_stations_v.duty_station_desc%TYPE);
163: --
164: PROCEDURE get_SF52_person_ddf_details (p_person_id IN per_people_f.person_id%TYPE
165: ,p_date_effective IN date default sysdate
166: ,p_citizenship OUT NOCOPY varchar2