[Home] [Help]
337: select '1'
338: into l_exists
339: from sys.dual
340: where exists(select null
341: from per_job_requirements jre1
342: where jre1.position_id = p_position_id);
343: exception when no_data_found then
344: null;
345: end;