APPS.GHR_EHRI_DYNRPT dependencies on GHR_DUTY_STATIONS_F

Line 869: l_duty_station_code ghr_duty_stations_f.duty_station_code%TYPE;

865: l_asgn_data per_all_assignments_f%ROWTYPE;
866: l_assignment_id NUMBER;
867: l_location_id NUMBER;
868: l_duty_station_id NUMBER;
869: l_duty_station_code ghr_duty_stations_f.duty_station_code%TYPE;
870: l_dummy_varchar VARCHAR2(2000);
871: l_dummy_number NUMBER;
872:
873: --8275231

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

1071: -- Bug# 3231946 Added parameter p_duty_station_code to fix the bug.
1072: -- With the addition of new parameter, this function can be used to find
1073: -- the locality pay area code by passing either duty_station_id or duty_station_code.
1074: FUNCTION get_loc_pay_area_code(
1075: p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE default NULL,
1076: p_duty_station_code IN ghr_duty_stations_f.duty_station_code%TYPE default NULL,
1077: p_effective_date IN DATE)
1078: RETURN VARCHAR2 IS
1079: l_result ghr_locality_pay_areas_f.locality_pay_area_code%TYPE;

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

1072: -- With the addition of new parameter, this function can be used to find
1073: -- the locality pay area code by passing either duty_station_id or duty_station_code.
1074: FUNCTION get_loc_pay_area_code(
1075: p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE default NULL,
1076: p_duty_station_code IN ghr_duty_stations_f.duty_station_code%TYPE default NULL,
1077: p_effective_date IN DATE)
1078: RETURN VARCHAR2 IS
1079: l_result ghr_locality_pay_areas_f.locality_pay_area_code%TYPE;
1080: BEGIN

Line 1086: ,ghr_duty_stations_f dst

1082: IF p_duty_station_id is NOT NULL THEN
1083: SELECT lpa.locality_pay_area_code
1084: INTO l_result
1085: FROM ghr_locality_pay_areas_f lpa
1086: ,ghr_duty_stations_f dst
1087: WHERE dst.duty_station_id = p_duty_station_id
1088: AND NVL(p_effective_date,TRUNC(sysdate))
1089: BETWEEN dst.effective_start_date and dst.effective_end_date
1090: AND dst.locality_pay_area_id = lpa.locality_pay_area_id

Line 1097: ,ghr_duty_stations_f dst

1093: ELSIF p_duty_station_code is NOT NULL THEN
1094: SELECT lpa.locality_pay_area_code
1095: INTO l_result
1096: FROM ghr_locality_pay_areas_f lpa
1097: ,ghr_duty_stations_f dst
1098: WHERE dst.duty_station_code = p_duty_station_code
1099: AND NVL(p_effective_date,TRUNC(sysdate))
1100: BETWEEN dst.effective_start_date and dst.effective_end_date
1101: AND dst.locality_pay_area_id = lpa.locality_pay_area_id