APPS.GHR_CPDF_DYNRPT dependencies on GHR_LOCALITY_PAY_AREAS_F

Line 788: l_result ghr_locality_pay_areas_f.locality_pay_area_code%TYPE;

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
790:
791: IF p_duty_station_id is NOT NULL THEN
792: SELECT lpa.locality_pay_area_code

Line 794: FROM ghr_locality_pay_areas_f lpa

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

Line 805: FROM ghr_locality_pay_areas_f lpa

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

Line 1260: l_locality_pay_area_code ghr_locality_pay_areas_f.locality_pay_area_code%type;

1256: l_message_name ghr_process_log.message_name%type;
1257: l_log_date ghr_process_log.log_date%type;
1258:
1259: -- Bug 4542476
1260: l_locality_pay_area_code ghr_locality_pay_areas_f.locality_pay_area_code%type;
1261: l_equiv_plan ghr_pay_plans.equivalent_pay_plan%type;
1262: -- End Bug 4542476
1263:
1264: