APPS.GHR_PA_REQUESTS_PKG dependencies on GHR_DUTY_STATIONS_V

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

107: ,p_last_name IN OUT NOCOPY per_people_f.last_name%TYPE
108: ,p_first_name IN OUT NOCOPY per_people_f.first_name%TYPE
109: ,p_middle_names IN OUT NOCOPY per_people_f.middle_names%TYPE);
110: --
111: PROCEDURE get_duty_station_details (p_duty_station_id IN ghr_duty_stations_v.duty_station_id%TYPE
112: ,p_effective_date IN DATE
113: ,p_duty_station_code IN OUT NOCOPY ghr_duty_stations_v.duty_station_code%TYPE
114: ,p_duty_station_desc IN OUT NOCOPY ghr_duty_stations_v.duty_station_desc%TYPE);
115: --

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

109: ,p_middle_names IN OUT NOCOPY per_people_f.middle_names%TYPE);
110: --
111: PROCEDURE get_duty_station_details (p_duty_station_id IN ghr_duty_stations_v.duty_station_id%TYPE
112: ,p_effective_date IN DATE
113: ,p_duty_station_code IN OUT NOCOPY ghr_duty_stations_v.duty_station_code%TYPE
114: ,p_duty_station_desc IN OUT NOCOPY ghr_duty_stations_v.duty_station_desc%TYPE);
115: --
116: PROCEDURE get_SF52_person_ddf_details (p_person_id IN per_people_f.person_id%TYPE
117: ,p_date_effective IN date default sysdate

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

110: --
111: PROCEDURE get_duty_station_details (p_duty_station_id IN ghr_duty_stations_v.duty_station_id%TYPE
112: ,p_effective_date IN DATE
113: ,p_duty_station_code IN OUT NOCOPY ghr_duty_stations_v.duty_station_code%TYPE
114: ,p_duty_station_desc IN OUT NOCOPY ghr_duty_stations_v.duty_station_desc%TYPE);
115: --
116: PROCEDURE get_SF52_person_ddf_details (p_person_id IN per_people_f.person_id%TYPE
117: ,p_date_effective IN date default sysdate
118: ,p_citizenship OUT NOCOPY varchar2