APPS.GHR_CPDF_DYNRPT dependencies on GHR_LOCALITY_PAY_AREAS_F

Line 741: l_result ghr_locality_pay_areas_f.locality_pay_area_code%TYPE;

737: p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE default NULL,
738: p_duty_station_code IN ghr_duty_stations_f.duty_station_code%TYPE default NULL,
739: p_effective_date IN DATE)
740: RETURN VARCHAR2 IS
741: l_result ghr_locality_pay_areas_f.locality_pay_area_code%TYPE;
742: BEGIN
743:
744: IF p_duty_station_id is NOT NULL THEN
745: SELECT lpa.locality_pay_area_code

Line 747: FROM ghr_locality_pay_areas_f lpa

743:
744: IF p_duty_station_id is NOT NULL THEN
745: SELECT lpa.locality_pay_area_code
746: INTO l_result
747: FROM ghr_locality_pay_areas_f lpa
748: ,ghr_duty_stations_f dst
749: WHERE dst.duty_station_id = p_duty_station_id
750: AND NVL(p_effective_date,TRUNC(sysdate))
751: BETWEEN dst.effective_start_date and dst.effective_end_date

Line 758: FROM ghr_locality_pay_areas_f lpa

754: BETWEEN lpa.effective_start_date and lpa.effective_end_date;
755: ELSIF p_duty_station_code is NOT NULL THEN
756: SELECT lpa.locality_pay_area_code
757: INTO l_result
758: FROM ghr_locality_pay_areas_f lpa
759: ,ghr_duty_stations_f dst
760: WHERE dst.duty_station_code = p_duty_station_code
761: AND NVL(p_effective_date,TRUNC(sysdate))
762: BETWEEN dst.effective_start_date and dst.effective_end_date

Line 1195: l_locality_pay_area_code ghr_locality_pay_areas_f.locality_pay_area_code%type;

1191: l_message_name ghr_process_log.message_name%type;
1192: l_log_date ghr_process_log.log_date%type;
1193:
1194: -- Bug 4542476
1195: l_locality_pay_area_code ghr_locality_pay_areas_f.locality_pay_area_code%type;
1196: l_equiv_plan ghr_pay_plans.equivalent_pay_plan%type;
1197: -- End Bug 4542476
1198:
1199: