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_DUTY_STATIONS_F

Line 487: FUNCTION get_lpa_percentage (p_duty_station_id ghr_duty_stations_f.duty_station_id%TYPE

483: END;
484: --
485: --------------------------- ------------------------------------
486: --
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;

Line 496: ,ghr_duty_stations_f dst

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
500: AND NVL(p_effective_date,TRUNC(sysdate)) between lpa.effective_start_date and lpa.effective_end_date;

Line 514: FUNCTION get_leo_lpa_percentage (p_duty_station_id ghr_duty_stations_f.duty_station_id%TYPE

510: --
511: --
512: --------------------------- ------------------------------------
513: --
514: FUNCTION get_leo_lpa_percentage (p_duty_station_id ghr_duty_stations_f.duty_station_id%TYPE
515: ,p_effective_date DATE)
516: RETURN NUMBER IS
517:
518: l_ret_val NUMBER := NULL;

Line 523: ,ghr_duty_stations_f dst

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
527: AND NVL(p_effective_date,TRUNC(sysdate)) between lpa.effective_start_date and lpa.effective_end_date;

Line 532: ,ghr_duty_stations_f dst

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
536: AND NVL(p_effective_date,TRUNC(sysdate)) between lpa.effective_start_date and lpa.effective_end_date;

Line 541: FROM ghr_duty_stations_f

537: --
538:
539: CURSOR cur_leo_code IS
540: SELECT leo_pay_area_code
541: FROM ghr_duty_stations_f
542: WHERE duty_station_id = p_duty_station_id
543: AND NVL(p_effective_date,TRUNC(sysdate))
544: between effective_start_date and effective_end_date;
545:

Line 546: l_leo_pay_area_code ghr_duty_stations_f.leo_pay_area_code%type;

542: WHERE duty_station_id = p_duty_station_id
543: AND NVL(p_effective_date,TRUNC(sysdate))
544: between effective_start_date and effective_end_date;
545:
546: l_leo_pay_area_code ghr_duty_stations_f.leo_pay_area_code%type;
547:
548: BEGIN
549: l_leo_pay_area_code := NULL;
550: FOR cur_leo_code_rec IN cur_leo_code LOOP

Line 876: ,p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE

872: -- Returns TRUE if it is a LEO Position
873: FUNCTION LEO_position (p_prd IN VARCHAR2
874: ,p_position_id IN NUMBER
875: ,p_retained_user_table_id IN NUMBER
876: ,p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
877: ,p_effective_date IN DATE)
878: RETURN BOOLEAN IS
879:
880: l_pay_table varchar2(4);

Line 1051: l_duty_station_code ghr_duty_stations_f.duty_station_code%TYPE;

1047: l_ret_flag BOOLEAN := FALSE;
1048: l_retained_grade ghr_pay_calc.retained_grade_rec_type;
1049:
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'

Line 1058: cursor c_fp_fo_duty_stn(p_duty_station_id ghr_duty_stations_f.duty_station_id%TYPE, p_effective_date DATE) 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
1059: select duty_station_code from ghr_duty_stations_f
1060: where substr(duty_station_code,1,2) between 'AA' and 'ZZ'
1061: and substr(duty_station_code,2,1)<> 'Q'
1062: and duty_station_id = p_duty_station_id

Line 1059: select duty_station_code from ghr_duty_stations_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
1059: select duty_station_code from ghr_duty_stations_f
1060: where substr(duty_station_code,1,2) between 'AA' and 'ZZ'
1061: and substr(duty_station_code,2,1)<> 'Q'
1062: and duty_station_id = p_duty_station_id
1063: AND NVL(p_effective_date,TRUNC(sysdate)) between effective_start_date and effective_end_date;

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 5329: ,p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE

5325: ,p_grade_or_level IN VARCHAR2
5326: ,p_effective_date IN DATE
5327: ,p_basic_pay IN NUMBER
5328: ,p_adj_basic_pay IN NUMBER
5329: ,p_duty_station_id IN ghr_duty_stations_f.duty_station_id%TYPE
5330: ,p_prd IN ghr_pa_requests.pay_rate_determinant%type
5331: ,p_pay_basis IN VARCHAR2
5332: ,p_person_id IN per_people_f.person_id%TYPE
5333: ,p_award_amount OUT NOCOPY NUMBER