APPS.GHR_CPDF_DYNRPT dependencies on GHR_DUTY_STATIONS_F

Line 574: l_duty_station_code ghr_duty_stations_f.duty_station_code%TYPE;

570: l_asgn_data per_all_assignments_f%ROWTYPE;
571: l_assignment_id NUMBER;
572: l_location_id NUMBER;
573: l_duty_station_id NUMBER;
574: l_duty_station_code ghr_duty_stations_f.duty_station_code%TYPE;
575: l_dummy_varchar VARCHAR2(2000);
576: l_dummy_number NUMBER;
577:
578: --8275231

Line 784: p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE default NULL,

780: -- Bug# 3231946 Added parameter p_duty_station_code to fix the bug.
781: -- With the addition of new parameter, this function can be used to find
782: -- the locality pay area code by passing either duty_station_id or duty_station_code.
783: FUNCTION get_loc_pay_area_code(
784: p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE default NULL,
785: p_duty_station_code IN ghr_duty_stations_f.duty_station_code%TYPE default NULL,
786: p_effective_date IN DATE)
787: RETURN VARCHAR2 IS
788: l_result ghr_locality_pay_areas_f.locality_pay_area_code%TYPE;

Line 785: p_duty_station_code IN ghr_duty_stations_f.duty_station_code%TYPE default NULL,

781: -- With the addition of new parameter, this function can be used to find
782: -- the locality pay area code by passing either duty_station_id or duty_station_code.
783: FUNCTION get_loc_pay_area_code(
784: p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE default NULL,
785: p_duty_station_code IN ghr_duty_stations_f.duty_station_code%TYPE default NULL,
786: p_effective_date IN DATE)
787: RETURN VARCHAR2 IS
788: l_result ghr_locality_pay_areas_f.locality_pay_area_code%TYPE;
789: BEGIN

Line 795: ,ghr_duty_stations_f dst

791: IF p_duty_station_id is NOT NULL THEN
792: SELECT lpa.locality_pay_area_code
793: INTO l_result
794: FROM ghr_locality_pay_areas_f lpa
795: ,ghr_duty_stations_f dst
796: WHERE dst.duty_station_id = p_duty_station_id
797: AND NVL(p_effective_date,TRUNC(sysdate))
798: BETWEEN dst.effective_start_date and dst.effective_end_date
799: AND dst.locality_pay_area_id = lpa.locality_pay_area_id

Line 806: ,ghr_duty_stations_f dst

802: ELSIF p_duty_station_code is NOT NULL THEN
803: SELECT lpa.locality_pay_area_code
804: INTO l_result
805: FROM ghr_locality_pay_areas_f lpa
806: ,ghr_duty_stations_f dst
807: WHERE dst.duty_station_code = p_duty_station_code
808: AND NVL(p_effective_date,TRUNC(sysdate))
809: BETWEEN dst.effective_start_date and dst.effective_end_date
810: AND dst.locality_pay_area_id = lpa.locality_pay_area_id