eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_PAY_CALC dependencies on GHR_LOCALITY_PAY_AREAS_F

Line 491: l_ret_val ghr_locality_pay_areas_f.adjustment_percentage%TYPE := NULL;

487: FUNCTION get_lpa_percentage (p_duty_station_id ghr_duty_stations_f.duty_station_id%TYPE
488: ,p_effective_date DATE)
489: RETURN NUMBER IS
490:
491: l_ret_val ghr_locality_pay_areas_f.adjustment_percentage%TYPE := NULL;
492: --
493: CURSOR cur_lpa IS
494: SELECT lpa.adjustment_percentage
495: FROM ghr_locality_pay_areas_f lpa

Line 495: FROM ghr_locality_pay_areas_f lpa

491: l_ret_val ghr_locality_pay_areas_f.adjustment_percentage%TYPE := NULL;
492: --
493: CURSOR cur_lpa IS
494: SELECT lpa.adjustment_percentage
495: FROM ghr_locality_pay_areas_f lpa
496: ,ghr_duty_stations_f dst
497: WHERE dst.duty_station_id = p_duty_station_id
498: AND NVL(p_effective_date,TRUNC(sysdate)) between dst.effective_start_date and dst.effective_end_date
499: AND dst.locality_pay_area_id = lpa.locality_pay_area_id

Line 522: FROM ghr_locality_pay_areas_f lpa

518: l_ret_val NUMBER := NULL;
519: --
520: CURSOR cur_lpa IS
521: SELECT NVL(lpa.leo_adjustment_percentage, lpa.adjustment_percentage) adj_percentage
522: FROM ghr_locality_pay_areas_f lpa
523: ,ghr_duty_stations_f dst
524: WHERE dst.duty_station_id = p_duty_station_id
525: AND NVL(p_effective_date,TRUNC(sysdate)) between dst.effective_start_date and dst.effective_end_date
526: AND dst.locality_pay_area_id = lpa.locality_pay_area_id

Line 531: FROM ghr_locality_pay_areas_f lpa

527: AND NVL(p_effective_date,TRUNC(sysdate)) between lpa.effective_start_date and lpa.effective_end_date;
528: --
529: CURSOR cur_lpa_geo_null IS
530: SELECT lpa.adjustment_percentage adj_percentage
531: FROM ghr_locality_pay_areas_f lpa
532: ,ghr_duty_stations_f dst
533: WHERE dst.duty_station_id = p_duty_station_id
534: AND NVL(p_effective_date,TRUNC(sysdate)) between dst.effective_start_date and dst.effective_end_date
535: AND dst.locality_pay_area_id = lpa.locality_pay_area_id

Line 1001: l_adjustment_percentage ghr_locality_pay_areas_f.adjustment_percentage%TYPE;

997: l_basic_pay_pos_pa NUMBER;
998: l_basic_pay_std NUMBER;
999: l_dummy_date DATE;
1000: l_locality_adj NUMBER;
1001: l_adjustment_percentage ghr_locality_pay_areas_f.adjustment_percentage%TYPE;
1002: l_default_basic_pay NUMBER;
1003: l_default_adj_basic_pay NUMBER;
1004: l_new_adj_basic_pay NUMBER; --AVR
1005: l_grade_or_level VARCHAR2(60); --AVR

Line 1054: select adjustment_percentage from ghr_locality_pay_areas_f

1050: --Begin Bug# 9156723
1051: l_duty_station_code ghr_duty_stations_f.duty_station_code%TYPE;
1052:
1053: CURSOR c_get_wcd_loc IS
1054: select adjustment_percentage from ghr_locality_pay_areas_f
1055: where locality_pay_area_code = 'WA'
1056: AND NVL(p_pay_calc_data.effective_date,TRUNC(sysdate)) between effective_start_date and effective_end_date;
1057:
1058: cursor c_fp_fo_duty_stn(p_duty_station_id ghr_duty_stations_f.duty_station_id%TYPE, p_effective_date DATE) is

Line 1918: FROM ghr_duty_stations_f ds, ghr_locality_pay_areas_f lc

1914: --Bug # 9513518
1915: CURSOR get_locality_pay_area
1916: IS
1917: SELECT lc.locality_pay_area_code
1918: FROM ghr_duty_stations_f ds, ghr_locality_pay_areas_f lc
1919: WHERE ds.duty_station_id = NVL(p_duty_station_id,l_ghr_pa_request_rec.duty_station_id)
1920: AND ds.locality_pay_area_id = lc.locality_pay_area_id
1921: AND p_effective_date between ds.effective_start_date and ds.effective_end_date
1922: AND p_effective_date between lc.effective_start_date and lc.effective_end_date;

Line 1924: l_locality_pay_area_code ghr_locality_pay_areas_f.locality_pay_area_code%type;

1920: AND ds.locality_pay_area_id = lc.locality_pay_area_id
1921: AND p_effective_date between ds.effective_start_date and ds.effective_end_date
1922: AND p_effective_date between lc.effective_start_date and lc.effective_end_date;
1923:
1924: l_locality_pay_area_code ghr_locality_pay_areas_f.locality_pay_area_code%type;
1925: --End Bug # 9513518
1926:
1927:
1928: BEGIN

Line 3297: l_adjustment_percentage ghr_locality_pay_areas_f.adjustment_percentage%TYPE;

3293:
3294: l_std_user_table_id NUMBER;
3295: l_user_table_id NUMBER;
3296: l_user_table_name pay_user_tables.user_table_name%type;
3297: l_adjustment_percentage ghr_locality_pay_areas_f.adjustment_percentage%TYPE;
3298: l_new_std_relative_rate NUMBER;
3299:
3300:
3301: l_grade VARCHAR2(30);

Line 3588: l_adjustment_percentage ghr_locality_pay_areas_f.adjustment_percentage%TYPE;

3584: ,p_new_adj_basic_pay OUT NOCOPY NUMBER
3585: ,p_new_locality_adj OUT NOCOPY NUMBER) IS
3586:
3587: l_std_user_table_id NUMBER;
3588: l_adjustment_percentage ghr_locality_pay_areas_f.adjustment_percentage%TYPE;
3589:
3590: l_grade VARCHAR2(30);
3591:
3592: l_std_min NUMBER;

Line 3765: l_adjustment_percentage ghr_locality_pay_areas_f.adjustment_percentage%TYPE;

3761: ,p_new_locality_adj OUT NOCOPY NUMBER) IS
3762:
3763: l_std_user_table_id NUMBER;
3764: l_user_table_id NUMBER;
3765: l_adjustment_percentage ghr_locality_pay_areas_f.adjustment_percentage%TYPE;
3766:
3767: l_grade VARCHAR2(30);
3768:
3769: l_std_min NUMBER;

Line 4136: l_adjustment_percentage ghr_locality_pay_areas_f.adjustment_percentage%type;

4132:
4133: --Bug # 10043212
4134: l_old_pp_grd_exists BOOLEAN;
4135:
4136: l_adjustment_percentage ghr_locality_pay_areas_f.adjustment_percentage%type;
4137:
4138: l_old_special_rate NUMBER;
4139: l_special_rate NUMBER; --for bug 4999237
4140: l_gm_pay_plan BOOLEAN;

Line 5341: l_adjustment_percentage ghr_locality_pay_areas_f.adjustment_percentage%type;

5337: l_PT_value NUMBER;
5338: l_PT_eff_start_date DATE;
5339: l_PT_eff_end_date DATE;
5340: l_equivalent_pay_plan ghr_pay_plans.equivalent_pay_plan%type;
5341: l_adjustment_percentage ghr_locality_pay_areas_f.adjustment_percentage%type;
5342: l_max_step ghr_pay_plans.maximum_step%type;
5343: l_locality_adj NUMBER;
5344: l_leo_flag BOOLEAN;
5345: l_std_user_table_id NUMBER;