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.52.12020000.6 2012/12/17 06:15:53 utokachi 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 1352: FROM GHR_DUTY_STATIONS_F

1348: l_log_date ghr_process_log.log_date%type;
1349:
1350: CURSOR DUTSTACUR IS
1351: SELECT DUTY_STATION_CODE, DUTY_STATION_ID
1352: FROM GHR_DUTY_STATIONS_F
1353: WHERE trunc(p_sr_report_date) between effective_start_date and
1354: nvl(effective_end_date, p_sr_report_date)
1355: AND DUTY_STATION_ID =
1356: (SELECT LEI_INFORMATION3

Line 1822: FROM GHR_DUTY_STATIONS_F

1818: l_log_date ghr_process_log.log_date%type;
1819:
1820: CURSOR CALCDUTSTA_CUR IS
1821: SELECT STATE_OR_COUNTRY_CODE
1822: FROM GHR_DUTY_STATIONS_F
1823: WHERE trunc(p_report_date) between effective_start_date and
1824: nvl(effective_end_date, p_report_date)
1825: AND DUTY_STATION_ID =
1826: (SELECT LEI_INFORMATION3

Line 1831: l_STATE_CNTRY_CODE GHR_DUTY_STATIONS_F.STATE_OR_COUNTRY_CODE%TYPE;

1827: FROM HR_LOCATION_EXTRA_INFO
1828: WHERE INFORMATION_TYPE = 'GHR_US_LOC_INFORMATION'
1829: AND LOCATION_ID = g_location_id);
1830:
1831: l_STATE_CNTRY_CODE GHR_DUTY_STATIONS_F.STATE_OR_COUNTRY_CODE%TYPE;
1832:
1833: BEGIN
1834: hr_utility.set_location('Entering:'||l_proc,5);
1835: