203: and parameter_value = 'Y'
204: and rownum < 2
205: AND QUERY_ID IN
206: ( select query_id from jtf_perz_query where profile_id in
207: ( select profile_id from jtf_perz_profile where profile_name = profilename ));
208:
209: RETURN l_query_id;
210: EXCEPTION
211: WHEN NO_DATA_FOUND
214: SELECT query_id
215: INTO l_query_id
216: FROM jtf_perz_query
217: WHERE profile_id IN ( SELECT profile_id
218: FROM jtf_perz_profile
219: WHERE profile_name = '-99999:JTF_TASK');
220: RETURN l_query_id;
221: END;
222: END;