eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_TASK_SECURITY_PVT dependencies on JTF_PERZ_QUERY

Line 201: FROM jtf_perz_query_param

197: BEGIN
198: BEGIN
199: SELECT query_id
200: INTO l_query_id
201: FROM jtf_perz_query_param
202: WHERE parameter_name = p_parameter_name
203: and parameter_value = 'Y'
204: and rownum < 2
205: AND QUERY_ID IN

Line 206: ( select query_id from jtf_perz_query where profile_id in

202: WHERE parameter_name = p_parameter_name
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

Line 216: FROM jtf_perz_query

212: THEN
213: BEGIN
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;