APPS.JTF_RS_JSP_LOV_RECS_PUB dependencies on JTF_RS_ROLES_VL

Line 364: from jtf_rs_roles_vl jrr,

360: -- Get the total count if "Last" hyperlink is clicked
361: IF (p_range_high < 0) THEN
362: SELECT count(*)
363: INTO l_total_count
364: from jtf_rs_roles_vl jrr,
365: fnd_lookups flk
366: where UPPER(role_name) like l_display_value
367: and jrr.role_type_code like l_aux_value1
368: and flk.meaning like l_aux_value2

Line 389: from jtf_rs_roles_vl jrr,

385:
386: OPEN lov_output_cur FOR
387:
388: select jrr.role_name, to_char(jrr.role_id), jrr.role_type_code, flk.meaning, null, '%'||manager_flag||'%', '%'||admin_flag||'%', '%'||member_flag||'%', '%'||lead_flag||'%', null
389: from jtf_rs_roles_vl jrr,
390: fnd_lookups flk
391: where UPPER(role_name) like l_display_value
392: and jrr.role_type_code like l_aux_value1
393: and flk.meaning like l_aux_value2