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 1652: l_lpa_area ghr_locality_pay_areas_f.locality_pay_area_code%type;

1648: ,p_agency_subelement in varchar2
1649: ,p_duty_station_Code in varchar2
1650: ,p_special_pay_table_id in varchar2 --Bug# 5745356(upd50)
1651: ) is
1652: l_lpa_area ghr_locality_pay_areas_f.locality_pay_area_code%type;
1653: l_lpa_pct ghr_locality_pay_areas_f.adjustment_percentage%type;
1654: l_leo_pct ghr_locality_pay_areas_f.leo_adjustment_percentage%type;
1655: l_lpa_effective_start_date ghr_locality_pay_areas_f.effective_start_date%type;
1656: l_lpa_effective_end_date ghr_locality_pay_areas_f.effective_end_date%type;

Line 1653: l_lpa_pct ghr_locality_pay_areas_f.adjustment_percentage%type;

1649: ,p_duty_station_Code in varchar2
1650: ,p_special_pay_table_id in varchar2 --Bug# 5745356(upd50)
1651: ) is
1652: l_lpa_area ghr_locality_pay_areas_f.locality_pay_area_code%type;
1653: l_lpa_pct ghr_locality_pay_areas_f.adjustment_percentage%type;
1654: l_leo_pct ghr_locality_pay_areas_f.leo_adjustment_percentage%type;
1655: l_lpa_effective_start_date ghr_locality_pay_areas_f.effective_start_date%type;
1656: l_lpa_effective_end_date ghr_locality_pay_areas_f.effective_end_date%type;
1657: l_lpa_pct_max ghr_locality_pay_areas_f.adjustment_percentage%type;

Line 1654: l_leo_pct ghr_locality_pay_areas_f.leo_adjustment_percentage%type;

1650: ,p_special_pay_table_id in varchar2 --Bug# 5745356(upd50)
1651: ) is
1652: l_lpa_area ghr_locality_pay_areas_f.locality_pay_area_code%type;
1653: l_lpa_pct ghr_locality_pay_areas_f.adjustment_percentage%type;
1654: l_leo_pct ghr_locality_pay_areas_f.leo_adjustment_percentage%type;
1655: l_lpa_effective_start_date ghr_locality_pay_areas_f.effective_start_date%type;
1656: l_lpa_effective_end_date ghr_locality_pay_areas_f.effective_end_date%type;
1657: l_lpa_pct_max ghr_locality_pay_areas_f.adjustment_percentage%type;
1658: l_lpa_pct_min ghr_locality_pay_areas_f.adjustment_percentage%type;

Line 1655: l_lpa_effective_start_date ghr_locality_pay_areas_f.effective_start_date%type;

1651: ) is
1652: l_lpa_area ghr_locality_pay_areas_f.locality_pay_area_code%type;
1653: l_lpa_pct ghr_locality_pay_areas_f.adjustment_percentage%type;
1654: l_leo_pct ghr_locality_pay_areas_f.leo_adjustment_percentage%type;
1655: l_lpa_effective_start_date ghr_locality_pay_areas_f.effective_start_date%type;
1656: l_lpa_effective_end_date ghr_locality_pay_areas_f.effective_end_date%type;
1657: l_lpa_pct_max ghr_locality_pay_areas_f.adjustment_percentage%type;
1658: l_lpa_pct_min ghr_locality_pay_areas_f.adjustment_percentage%type;
1659: l_effective_date date;

Line 1656: l_lpa_effective_end_date ghr_locality_pay_areas_f.effective_end_date%type;

1652: l_lpa_area ghr_locality_pay_areas_f.locality_pay_area_code%type;
1653: l_lpa_pct ghr_locality_pay_areas_f.adjustment_percentage%type;
1654: l_leo_pct ghr_locality_pay_areas_f.leo_adjustment_percentage%type;
1655: l_lpa_effective_start_date ghr_locality_pay_areas_f.effective_start_date%type;
1656: l_lpa_effective_end_date ghr_locality_pay_areas_f.effective_end_date%type;
1657: l_lpa_pct_max ghr_locality_pay_areas_f.adjustment_percentage%type;
1658: l_lpa_pct_min ghr_locality_pay_areas_f.adjustment_percentage%type;
1659: l_effective_date date;
1660: l_pay_table VARCHAR2(4); --Bug# 5745356(upd50)

Line 1657: l_lpa_pct_max ghr_locality_pay_areas_f.adjustment_percentage%type;

1653: l_lpa_pct ghr_locality_pay_areas_f.adjustment_percentage%type;
1654: l_leo_pct ghr_locality_pay_areas_f.leo_adjustment_percentage%type;
1655: l_lpa_effective_start_date ghr_locality_pay_areas_f.effective_start_date%type;
1656: l_lpa_effective_end_date ghr_locality_pay_areas_f.effective_end_date%type;
1657: l_lpa_pct_max ghr_locality_pay_areas_f.adjustment_percentage%type;
1658: l_lpa_pct_min ghr_locality_pay_areas_f.adjustment_percentage%type;
1659: l_effective_date date;
1660: l_pay_table VARCHAR2(4); --Bug# 5745356(upd50)
1661: l_table5_value number(10,2); --Bug# 8309414

Line 1658: l_lpa_pct_min ghr_locality_pay_areas_f.adjustment_percentage%type;

1654: l_leo_pct ghr_locality_pay_areas_f.leo_adjustment_percentage%type;
1655: l_lpa_effective_start_date ghr_locality_pay_areas_f.effective_start_date%type;
1656: l_lpa_effective_end_date ghr_locality_pay_areas_f.effective_end_date%type;
1657: l_lpa_pct_max ghr_locality_pay_areas_f.adjustment_percentage%type;
1658: l_lpa_pct_min ghr_locality_pay_areas_f.adjustment_percentage%type;
1659: l_effective_date date;
1660: l_pay_table VARCHAR2(4); --Bug# 5745356(upd50)
1661: l_table5_value number(10,2); --Bug# 8309414
1662:

Line 1667: FROM ghr_locality_pay_areas_f

1663: CURSOR c1 is
1664: SELECT effective_start_date, effective_end_date,
1665: NVL(adjustment_percentage,0),
1666: NVL(leo_adjustment_percentage,0)
1667: FROM ghr_locality_pay_areas_f
1668: WHERE locality_pay_area_code = p_locality_pay_area
1669: AND trunc(l_effective_date) between effective_start_date
1670: and nvl(effective_end_date, l_effective_date);
1671:

Line 2602: l_lpa_pct ghr_locality_pay_areas_f.adjustment_percentage%type;

2598: ,p_prior_duty_station in varchar2
2599: ,p_effective_date in date
2600: ) is
2601:
2602: l_lpa_pct ghr_locality_pay_areas_f.adjustment_percentage%type;
2603: l_leo_pct ghr_locality_pay_areas_f.leo_adjustment_percentage%type;
2604: l_lpa_effective_start_date pay_user_rows_f.effective_start_date%type;
2605: l_lpa_effective_end_date pay_user_rows_f.effective_end_date%type;
2606: l_table5_value number(10,2); --Bug# 8309414

Line 2603: l_leo_pct ghr_locality_pay_areas_f.leo_adjustment_percentage%type;

2599: ,p_effective_date in date
2600: ) is
2601:
2602: l_lpa_pct ghr_locality_pay_areas_f.adjustment_percentage%type;
2603: l_leo_pct ghr_locality_pay_areas_f.leo_adjustment_percentage%type;
2604: l_lpa_effective_start_date pay_user_rows_f.effective_start_date%type;
2605: l_lpa_effective_end_date pay_user_rows_f.effective_end_date%type;
2606: l_table5_value number(10,2); --Bug# 8309414
2607:

Line 2611: FROM ghr_locality_pay_areas_f

2607:
2608: CURSOR c1 is
2609: SELECT effective_start_date, effective_end_date,
2610: NVL(adjustment_percentage,0), NVL(leo_adjustment_percentage,0)
2611: FROM ghr_locality_pay_areas_f
2612: WHERE locality_pay_area_code = p_prior_locality_pay_area
2613: AND p_prior_loc_adj_effective_date BETWEEN effective_start_date and effective_end_date;
2614:
2615: begin