[Home] [Help]
153: select '1'
154: into l_exists
155: from sys.dual
156: where exists(SELECT NULL
157: from PER_VACANCIES VAC
158: where VAC.POSITION_ID = p_position_id);
159: exception when no_data_found then
160: null;
161: end;