APPS.GHR_CPDF_EHRIS dependencies on GHR_DUTY_STATIONS_F

Line 4: g_duty_station_id ghr_duty_stations_f.duty_station_id%TYPE;

1: PACKAGE BODY ghr_cpdf_ehris AS
2: /* $Header: ghrehris.pkb 120.34.12010000.2 2008/08/05 15:12:15 ubhat ship $ */
3:
4: g_duty_station_id ghr_duty_stations_f.duty_station_id%TYPE;
5: g_pay_table_name varchar2(30);
6: g_to_pay_plan varchar2(30);
7: g_retained_pay_table_name varchar2(30);
8:

Line 1306: FROM GHR_DUTY_STATIONS_F

1302: l_log_date ghr_process_log.log_date%type;
1303:
1304: CURSOR DUTSTACUR IS
1305: SELECT DUTY_STATION_CODE, DUTY_STATION_ID
1306: FROM GHR_DUTY_STATIONS_F
1307: WHERE trunc(p_sr_report_date) between effective_start_date and
1308: nvl(effective_end_date, p_sr_report_date)
1309: AND DUTY_STATION_ID =
1310: (SELECT LEI_INFORMATION3

Line 1745: FROM GHR_DUTY_STATIONS_F

1741: l_log_date ghr_process_log.log_date%type;
1742:
1743: CURSOR CALCDUTSTA_CUR IS
1744: SELECT STATE_OR_COUNTRY_CODE
1745: FROM GHR_DUTY_STATIONS_F
1746: WHERE trunc(p_report_date) between effective_start_date and
1747: nvl(effective_end_date, p_report_date)
1748: AND DUTY_STATION_ID =
1749: (SELECT LEI_INFORMATION3

Line 1754: l_STATE_CNTRY_CODE GHR_DUTY_STATIONS_F.STATE_OR_COUNTRY_CODE%TYPE;

1750: FROM HR_LOCATION_EXTRA_INFO
1751: WHERE INFORMATION_TYPE = 'GHR_US_LOC_INFORMATION'
1752: AND LOCATION_ID = g_location_id);
1753:
1754: l_STATE_CNTRY_CODE GHR_DUTY_STATIONS_F.STATE_OR_COUNTRY_CODE%TYPE;
1755:
1756: BEGIN
1757: hr_utility.set_location('Entering:'||l_proc,5);
1758: