DBA Data[Home] [Help]

APPS.GHR_MASS_AWARDS_ELIG dependencies on GHR_DUTY_STATIONS_F

Line 59: l_duty_station_code ghr_duty_stations_f.duty_station_code%type;

55: l_grade_exists boolean;
56: l_count number := 0;
57: l_pos_ei_data per_position_extra_info%rowtype;
58: l_effective_date date;
59: l_duty_station_code ghr_duty_stations_f.duty_station_code%type;
60: l_errbuf varchar2(2000);
61: l_retcode number;
62: l_status varchar2(30);
63: l_nc_status varchar2(30); --Added for nocopy changes.

Line 99: from ghr_duty_stations_f dsf

95:
96:
97: Cursor c_duty_station_code is
98: Select dsf.duty_station_code
99: from ghr_duty_stations_f dsf
100: where dsf.duty_station_id =
101: (select lei.lei_information3
102: from hr_location_extra_info lei
103: where lei.location_id = l_loc_id