APPS.GHR_EHRI_DYNRPT dependencies on GHR_LOCALITY_PAY_AREAS_F

Line 1033: l_result ghr_locality_pay_areas_f.locality_pay_area_code%TYPE;

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
1035:
1036: IF p_duty_station_id is NOT NULL THEN
1037: SELECT lpa.locality_pay_area_code

Line 1039: FROM ghr_locality_pay_areas_f lpa

1035:
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

Line 1050: FROM ghr_locality_pay_areas_f lpa

1046: BETWEEN lpa.effective_start_date and lpa.effective_end_date;
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

Line 2368: l_locality_pay_area_code ghr_locality_pay_areas_f.locality_pay_area_code%type;

2364: l_message_name ghr_process_log.message_name%type;
2365: l_log_date ghr_process_log.log_date%type;
2366:
2367: -- Bug 5011003
2368: l_locality_pay_area_code ghr_locality_pay_areas_f.locality_pay_area_code%type;
2369: l_equiv_plan ghr_pay_plans.equivalent_pay_plan%type;
2370: -- End Bug 5011003
2371: -- the following cursor can be used for dual purposes
2372: -- can pass the exact eff date or the eff_date-1 to pick the prior details