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.7.12000000.3 2007/03/02 05:48:03 vmididho noship $ */
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 664: FROM GHR_DUTY_STATIONS_F

660: l_proc varchar2(30) := 'get_from_history_dutsta';
661:
662: CURSOR DUTSTACUR IS
663: SELECT DUTY_STATION_CODE, DUTY_STATION_ID
664: FROM GHR_DUTY_STATIONS_F
665: WHERE trunc(p_sr_report_date) between effective_start_date and
666: nvl(effective_end_date, p_sr_report_date)
667: AND DUTY_STATION_ID =
668: (SELECT LEI_INFORMATION3

Line 873: FROM GHR_DUTY_STATIONS_F

869: IS
870: l_proc varchar2(30) := 'calc_is_foreign_duty_station';
871: CURSOR CALCDUTSTA_CUR IS
872: SELECT STATE_OR_COUNTRY_CODE
873: FROM GHR_DUTY_STATIONS_F
874: WHERE trunc(p_report_date) between effective_start_date and
875: nvl(effective_end_date, p_report_date)
876: AND DUTY_STATION_ID =
877: (SELECT LEI_INFORMATION3

Line 882: l_STATE_CNTRY_CODE GHR_DUTY_STATIONS_F.STATE_OR_COUNTRY_CODE%TYPE;

878: FROM HR_LOCATION_EXTRA_INFO
879: WHERE INFORMATION_TYPE = 'GHR_US_LOC_INFORMATION'
880: AND LOCATION_ID = g_location_id);
881:
882: l_STATE_CNTRY_CODE GHR_DUTY_STATIONS_F.STATE_OR_COUNTRY_CODE%TYPE;
883:
884: BEGIN
885: hr_utility.set_location('Entering:'||l_proc,5);
886: