APPS.GHR_PA_REQUESTS_PKG dependencies on GHR_DUTY_STATIONS_V

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

667: RAISE;
668:
669: END get_person_details;
670:
671: PROCEDURE get_duty_station_details (p_duty_station_id IN ghr_duty_stations_v.duty_station_id%TYPE
672: ,p_effective_date IN DATE
673: ,p_duty_station_code IN OUT NOCOPY ghr_duty_stations_v.duty_station_code%TYPE
674: ,p_duty_station_desc IN OUT NOCOPY ghr_duty_stations_v.duty_station_desc%TYPE) IS
675:

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

669: END get_person_details;
670:
671: PROCEDURE get_duty_station_details (p_duty_station_id IN ghr_duty_stations_v.duty_station_id%TYPE
672: ,p_effective_date IN DATE
673: ,p_duty_station_code IN OUT NOCOPY ghr_duty_stations_v.duty_station_code%TYPE
674: ,p_duty_station_desc IN OUT NOCOPY ghr_duty_stations_v.duty_station_desc%TYPE) IS
675:
676: l_duty_station_code ghr_duty_stations_v.duty_station_code%TYPE;
677: l_duty_station_desc ghr_duty_stations_v.duty_station_desc%TYPE;

Line 674: ,p_duty_station_desc IN OUT NOCOPY ghr_duty_stations_v.duty_station_desc%TYPE) IS

670:
671: PROCEDURE get_duty_station_details (p_duty_station_id IN ghr_duty_stations_v.duty_station_id%TYPE
672: ,p_effective_date IN DATE
673: ,p_duty_station_code IN OUT NOCOPY ghr_duty_stations_v.duty_station_code%TYPE
674: ,p_duty_station_desc IN OUT NOCOPY ghr_duty_stations_v.duty_station_desc%TYPE) IS
675:
676: l_duty_station_code ghr_duty_stations_v.duty_station_code%TYPE;
677: l_duty_station_desc ghr_duty_stations_v.duty_station_desc%TYPE;
678:

Line 676: l_duty_station_code ghr_duty_stations_v.duty_station_code%TYPE;

672: ,p_effective_date IN DATE
673: ,p_duty_station_code IN OUT NOCOPY ghr_duty_stations_v.duty_station_code%TYPE
674: ,p_duty_station_desc IN OUT NOCOPY ghr_duty_stations_v.duty_station_desc%TYPE) IS
675:
676: l_duty_station_code ghr_duty_stations_v.duty_station_code%TYPE;
677: l_duty_station_desc ghr_duty_stations_v.duty_station_desc%TYPE;
678:
679: CURSOR cur_dstv IS
680: SELECT dstv.duty_station_code

Line 677: l_duty_station_desc ghr_duty_stations_v.duty_station_desc%TYPE;

673: ,p_duty_station_code IN OUT NOCOPY ghr_duty_stations_v.duty_station_code%TYPE
674: ,p_duty_station_desc IN OUT NOCOPY ghr_duty_stations_v.duty_station_desc%TYPE) IS
675:
676: l_duty_station_code ghr_duty_stations_v.duty_station_code%TYPE;
677: l_duty_station_desc ghr_duty_stations_v.duty_station_desc%TYPE;
678:
679: CURSOR cur_dstv IS
680: SELECT dstv.duty_station_code
681: ,dstv.duty_station_desc

Line 682: FROM ghr_duty_stations_v dstv

678:
679: CURSOR cur_dstv IS
680: SELECT dstv.duty_station_code
681: ,dstv.duty_station_desc
682: FROM ghr_duty_stations_v dstv
683: WHERE dstv.duty_station_id = p_duty_station_id
684: AND NVL(p_effective_date,TRUNC(sysdate)) between dstv.effective_start_date and dstv.effective_end_date;
685: --
686: BEGIN

Line 2382: l_duty_station ghr_duty_stations_v.duty_station_code%type;

2378: ) RETURN varchar2 IS
2379:
2380:
2381: l_proc varchar2(72) := 'get_duty_station';
2382: l_duty_station ghr_duty_stations_v.duty_station_code%type;
2383: l_location_id hr_all_positions_f.location_id%type;
2384:
2385: CURSOR get_loc_id IS
2386: SELECT location_id

Line 2395: FROM hr_location_extra_info lei, ghr_duty_stations_v ds

2391:
2392:
2393: CURSOR get_duty_station_code IS
2394: select ds.duty_station_code
2395: FROM hr_location_extra_info lei, ghr_duty_stations_v ds
2396: WHERE lei.location_id = l_location_id
2397: AND lei.information_type = 'GHR_US_LOC_INFORMATION'
2398: and to_number(lei.lei_information3) = ds.duty_station_id
2399: and p_effective_date between ds.effective_start_date