APPS.GHR_EHRI_DYNRPT dependencies on GHR_LOCALITY_PAY_AREAS_F

Line 1079: l_result ghr_locality_pay_areas_f.locality_pay_area_code%TYPE;

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
1081:
1082: IF p_duty_station_id is NOT NULL THEN
1083: SELECT lpa.locality_pay_area_code

Line 1085: FROM ghr_locality_pay_areas_f lpa

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

Line 1096: FROM ghr_locality_pay_areas_f lpa

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

Line 2522: l_locality_pay_area_code ghr_locality_pay_areas_f.locality_pay_area_code%type;

2518: l_message_name ghr_process_log.message_name%type;
2519: l_log_date ghr_process_log.log_date%type;
2520:
2521: -- Bug 5011003
2522: l_locality_pay_area_code ghr_locality_pay_areas_f.locality_pay_area_code%type;
2523: l_equiv_plan ghr_pay_plans.equivalent_pay_plan%type;
2524: -- End Bug 5011003
2525: -- the following cursor can be used for dual purposes
2526: -- can pass the exact eff date or the eff_date-1 to pick the prior details