APPS.GHR_CPDF_STATRPT 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_statrpt AS
2: /* $Header: ghrcpdfs.pkb 120.16.12020000.2 2012/12/05 05:51:50 utokachi ship $ */
3:
4: g_duty_station_id ghr_duty_stations_f.duty_station_id%TYPE;
5: g_retained_pay_table_id pay_user_tables.user_table_id%TYPE;
6:
7: PROCEDURE initialize_record
8: IS

Line 694: FROM GHR_DUTY_STATIONS_F

690: l_proc varchar2(30) := 'get_from_history_dutsta';
691:
692: CURSOR DUTSTACUR IS
693: SELECT DUTY_STATION_CODE, DUTY_STATION_ID
694: FROM GHR_DUTY_STATIONS_F
695: WHERE trunc(p_sr_report_date) between effective_start_date and
696: nvl(effective_end_date, p_sr_report_date)
697: AND DUTY_STATION_ID =
698: (SELECT LEI_INFORMATION3

Line 903: FROM GHR_DUTY_STATIONS_F

899: IS
900: l_proc varchar2(30) := 'calc_is_foreign_duty_station';
901: CURSOR CALCDUTSTA_CUR IS
902: SELECT STATE_OR_COUNTRY_CODE
903: FROM GHR_DUTY_STATIONS_F
904: WHERE trunc(p_report_date) between effective_start_date and
905: nvl(effective_end_date, p_report_date)
906: AND DUTY_STATION_ID =
907: (SELECT LEI_INFORMATION3

Line 912: l_STATE_CNTRY_CODE GHR_DUTY_STATIONS_F.STATE_OR_COUNTRY_CODE%TYPE;

908: FROM HR_LOCATION_EXTRA_INFO
909: WHERE INFORMATION_TYPE = 'GHR_US_LOC_INFORMATION'
910: AND LOCATION_ID = g_location_id);
911:
912: l_STATE_CNTRY_CODE GHR_DUTY_STATIONS_F.STATE_OR_COUNTRY_CODE%TYPE;
913:
914: BEGIN
915: hr_utility.set_location('Entering:'||l_proc,5);
916: