APPS.GHR_EHRI_DYNRPT dependencies on GHR_DUTY_STATIONS_F

Line 865: l_duty_station_code ghr_duty_stations_f.duty_station_code%TYPE;

861: l_asgn_data per_all_assignments_f%ROWTYPE;
862: l_assignment_id NUMBER;
863: l_location_id NUMBER;
864: l_duty_station_id NUMBER;
865: l_duty_station_code ghr_duty_stations_f.duty_station_code%TYPE;
866: l_dummy_varchar VARCHAR2(2000);
867: l_dummy_number NUMBER;
868: BEGIN
869: -- If the PAR has happened then need to go to history to get it

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

1025: -- Bug# 3231946 Added parameter p_duty_station_code to fix the bug.
1026: -- With the addition of new parameter, this function can be used to find
1027: -- the locality pay area code by passing either duty_station_id or duty_station_code.
1028: FUNCTION get_loc_pay_area_code(
1029: p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE default NULL,
1030: p_duty_station_code IN ghr_duty_stations_f.duty_station_code%TYPE default NULL,
1031: p_effective_date IN DATE)
1032: RETURN VARCHAR2 IS
1033: l_result ghr_locality_pay_areas_f.locality_pay_area_code%TYPE;

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

1026: -- With the addition of new parameter, this function can be used to find
1027: -- the locality pay area code by passing either duty_station_id or duty_station_code.
1028: FUNCTION get_loc_pay_area_code(
1029: p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE default NULL,
1030: p_duty_station_code IN ghr_duty_stations_f.duty_station_code%TYPE default NULL,
1031: p_effective_date IN DATE)
1032: RETURN VARCHAR2 IS
1033: l_result ghr_locality_pay_areas_f.locality_pay_area_code%TYPE;
1034: BEGIN

Line 1040: ,ghr_duty_stations_f dst

1036: IF p_duty_station_id is NOT NULL THEN
1037: SELECT lpa.locality_pay_area_code
1038: INTO l_result
1039: FROM ghr_locality_pay_areas_f lpa
1040: ,ghr_duty_stations_f dst
1041: WHERE dst.duty_station_id = p_duty_station_id
1042: AND NVL(p_effective_date,TRUNC(sysdate))
1043: BETWEEN dst.effective_start_date and dst.effective_end_date
1044: AND dst.locality_pay_area_id = lpa.locality_pay_area_id

Line 1051: ,ghr_duty_stations_f dst

1047: ELSIF p_duty_station_code is NOT NULL THEN
1048: SELECT lpa.locality_pay_area_code
1049: INTO l_result
1050: FROM ghr_locality_pay_areas_f lpa
1051: ,ghr_duty_stations_f dst
1052: WHERE dst.duty_station_code = p_duty_station_code
1053: AND NVL(p_effective_date,TRUNC(sysdate))
1054: BETWEEN dst.effective_start_date and dst.effective_end_date
1055: AND dst.locality_pay_area_id = lpa.locality_pay_area_id