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_CPDF_CHECK7 dependencies on GHR_LOCALITY_PAY_AREAS_F

Line 1577: l_lpa_area ghr_locality_pay_areas_f.locality_pay_area_code%type;

1573: ,p_agency_subelement in varchar2
1574: ,p_duty_station_Code in varchar2
1575: ,p_special_pay_table_id in varchar2 --Bug# 5745356(upd50)
1576: ) is
1577: l_lpa_area ghr_locality_pay_areas_f.locality_pay_area_code%type;
1578: l_lpa_pct ghr_locality_pay_areas_f.adjustment_percentage%type;
1579: l_leo_pct ghr_locality_pay_areas_f.leo_adjustment_percentage%type;
1580: l_lpa_effective_start_date ghr_locality_pay_areas_f.effective_start_date%type;
1581: l_lpa_effective_end_date ghr_locality_pay_areas_f.effective_end_date%type;

Line 1578: l_lpa_pct ghr_locality_pay_areas_f.adjustment_percentage%type;

1574: ,p_duty_station_Code in varchar2
1575: ,p_special_pay_table_id in varchar2 --Bug# 5745356(upd50)
1576: ) is
1577: l_lpa_area ghr_locality_pay_areas_f.locality_pay_area_code%type;
1578: l_lpa_pct ghr_locality_pay_areas_f.adjustment_percentage%type;
1579: l_leo_pct ghr_locality_pay_areas_f.leo_adjustment_percentage%type;
1580: l_lpa_effective_start_date ghr_locality_pay_areas_f.effective_start_date%type;
1581: l_lpa_effective_end_date ghr_locality_pay_areas_f.effective_end_date%type;
1582: l_lpa_pct_max ghr_locality_pay_areas_f.adjustment_percentage%type;

Line 1579: l_leo_pct ghr_locality_pay_areas_f.leo_adjustment_percentage%type;

1575: ,p_special_pay_table_id in varchar2 --Bug# 5745356(upd50)
1576: ) is
1577: l_lpa_area ghr_locality_pay_areas_f.locality_pay_area_code%type;
1578: l_lpa_pct ghr_locality_pay_areas_f.adjustment_percentage%type;
1579: l_leo_pct ghr_locality_pay_areas_f.leo_adjustment_percentage%type;
1580: l_lpa_effective_start_date ghr_locality_pay_areas_f.effective_start_date%type;
1581: l_lpa_effective_end_date ghr_locality_pay_areas_f.effective_end_date%type;
1582: l_lpa_pct_max ghr_locality_pay_areas_f.adjustment_percentage%type;
1583: l_lpa_pct_min ghr_locality_pay_areas_f.adjustment_percentage%type;

Line 1580: l_lpa_effective_start_date ghr_locality_pay_areas_f.effective_start_date%type;

1576: ) is
1577: l_lpa_area ghr_locality_pay_areas_f.locality_pay_area_code%type;
1578: l_lpa_pct ghr_locality_pay_areas_f.adjustment_percentage%type;
1579: l_leo_pct ghr_locality_pay_areas_f.leo_adjustment_percentage%type;
1580: l_lpa_effective_start_date ghr_locality_pay_areas_f.effective_start_date%type;
1581: l_lpa_effective_end_date ghr_locality_pay_areas_f.effective_end_date%type;
1582: l_lpa_pct_max ghr_locality_pay_areas_f.adjustment_percentage%type;
1583: l_lpa_pct_min ghr_locality_pay_areas_f.adjustment_percentage%type;
1584: l_effective_date date;

Line 1581: l_lpa_effective_end_date ghr_locality_pay_areas_f.effective_end_date%type;

1577: l_lpa_area ghr_locality_pay_areas_f.locality_pay_area_code%type;
1578: l_lpa_pct ghr_locality_pay_areas_f.adjustment_percentage%type;
1579: l_leo_pct ghr_locality_pay_areas_f.leo_adjustment_percentage%type;
1580: l_lpa_effective_start_date ghr_locality_pay_areas_f.effective_start_date%type;
1581: l_lpa_effective_end_date ghr_locality_pay_areas_f.effective_end_date%type;
1582: l_lpa_pct_max ghr_locality_pay_areas_f.adjustment_percentage%type;
1583: l_lpa_pct_min ghr_locality_pay_areas_f.adjustment_percentage%type;
1584: l_effective_date date;
1585: l_pay_table VARCHAR2(4); --Bug# 5745356(upd50)

Line 1582: l_lpa_pct_max ghr_locality_pay_areas_f.adjustment_percentage%type;

1578: l_lpa_pct ghr_locality_pay_areas_f.adjustment_percentage%type;
1579: l_leo_pct ghr_locality_pay_areas_f.leo_adjustment_percentage%type;
1580: l_lpa_effective_start_date ghr_locality_pay_areas_f.effective_start_date%type;
1581: l_lpa_effective_end_date ghr_locality_pay_areas_f.effective_end_date%type;
1582: l_lpa_pct_max ghr_locality_pay_areas_f.adjustment_percentage%type;
1583: l_lpa_pct_min ghr_locality_pay_areas_f.adjustment_percentage%type;
1584: l_effective_date date;
1585: l_pay_table VARCHAR2(4); --Bug# 5745356(upd50)
1586:

Line 1583: l_lpa_pct_min ghr_locality_pay_areas_f.adjustment_percentage%type;

1579: l_leo_pct ghr_locality_pay_areas_f.leo_adjustment_percentage%type;
1580: l_lpa_effective_start_date ghr_locality_pay_areas_f.effective_start_date%type;
1581: l_lpa_effective_end_date ghr_locality_pay_areas_f.effective_end_date%type;
1582: l_lpa_pct_max ghr_locality_pay_areas_f.adjustment_percentage%type;
1583: l_lpa_pct_min ghr_locality_pay_areas_f.adjustment_percentage%type;
1584: l_effective_date date;
1585: l_pay_table VARCHAR2(4); --Bug# 5745356(upd50)
1586:
1587: CURSOR c1 is

Line 1591: FROM ghr_locality_pay_areas_f

1587: CURSOR c1 is
1588: SELECT effective_start_date, effective_end_date,
1589: NVL(adjustment_percentage,0),
1590: NVL(leo_adjustment_percentage,0)
1591: FROM ghr_locality_pay_areas_f
1592: WHERE locality_pay_area_code = p_locality_pay_area
1593: AND trunc(l_effective_date) between effective_start_date
1594: and nvl(effective_end_date, l_effective_date);
1595:

Line 2409: l_lpa_pct ghr_locality_pay_areas_f.adjustment_percentage%type;

2405: ,p_prior_duty_station in varchar2
2406: ,p_effective_date in date
2407: ) is
2408:
2409: l_lpa_pct ghr_locality_pay_areas_f.adjustment_percentage%type;
2410: l_leo_pct ghr_locality_pay_areas_f.leo_adjustment_percentage%type;
2411: l_lpa_effective_start_date pay_user_rows_f.effective_start_date%type;
2412: l_lpa_effective_end_date pay_user_rows_f.effective_end_date%type;
2413:

Line 2410: l_leo_pct ghr_locality_pay_areas_f.leo_adjustment_percentage%type;

2406: ,p_effective_date in date
2407: ) is
2408:
2409: l_lpa_pct ghr_locality_pay_areas_f.adjustment_percentage%type;
2410: l_leo_pct ghr_locality_pay_areas_f.leo_adjustment_percentage%type;
2411: l_lpa_effective_start_date pay_user_rows_f.effective_start_date%type;
2412: l_lpa_effective_end_date pay_user_rows_f.effective_end_date%type;
2413:
2414: CURSOR c1 is

Line 2417: FROM ghr_locality_pay_areas_f

2413:
2414: CURSOR c1 is
2415: SELECT effective_start_date, effective_end_date,
2416: NVL(adjustment_percentage,0), NVL(leo_adjustment_percentage,0)
2417: FROM ghr_locality_pay_areas_f
2418: WHERE locality_pay_area_code = p_prior_locality_pay_area
2419: AND p_prior_loc_adj_effective_date BETWEEN effective_start_date and effective_end_date;
2420:
2421: begin