DBA Data[Home] [Help]

APPS.GHR_LEI_FLEX_DDF dependencies on GHR_DUTY_STATIONS_F

Line 173: from ghr_duty_stations_f

169: WHERE session_id = USERENV('SESSIONID');
170:
171: cursor c2 (p_effective_date date) is
172: select 'X'
173: from ghr_duty_stations_f
174: where duty_station_id = to_number(p_lei_information3)
175: and trunc(p_effective_date) between(effective_start_date) and
176: nvl(effective_end_date,p_effective_date);
177: --