APPS.JTF_RS_JSP_LOV_RECS_PUB dependencies on FND_LOOKUPS

Line 113: from JTF_RS_RESOURCE_EXTNS_VL RES, FND_LOOKUPS FL

109: -- Get the total count if "Last" hyperlink is clicked
110: IF (p_range_high < 0) THEN
111: SELECT count(*)
112: INTO l_total_count
113: from JTF_RS_RESOURCE_EXTNS_VL RES, FND_LOOKUPS FL
114: where category like l_aux_value2
115: and resource_number like l_aux_value1
116: and UPPER(resource_name) like l_display_value
117: and trunc(sysdate) <= nvl(res.end_date_active,trunc(sysdate))

Line 145: from JTF_RS_RESOURCE_EXTNS_VL RES, FND_LOOKUPS FL

141: null ext_value2,
142: null ext_value3,
143: null ext_value4,
144: null ext_value5
145: from JTF_RS_RESOURCE_EXTNS_VL RES, FND_LOOKUPS FL
146: where category like l_aux_value2
147: and resource_number like l_aux_value1
148: and UPPER(resource_name) like l_display_value
149: and trunc(sysdate) <= nvl(res.end_date_active,trunc(sysdate))

Line 161: from JTF_RS_RESOURCE_EXTNS_VL RES, FND_LOOKUPS FL

157: -- Get the total count if "Last" hyperlink is clicked
158: IF (p_range_high < 0) THEN
159: SELECT count(*)
160: INTO l_total_count
161: from JTF_RS_RESOURCE_EXTNS_VL RES, FND_LOOKUPS FL
162: where resource_id <> l_filter_number1
163: and category like l_aux_value2
164: and resource_number like l_aux_value1
165: and UPPER(resource_name) like l_display_value

Line 193: from JTF_RS_RESOURCE_EXTNS_VL RES, FND_LOOKUPS FL

189: null ext_value2,
190: null ext_value3,
191: null ext_value4,
192: null ext_value5
193: from JTF_RS_RESOURCE_EXTNS_VL RES, FND_LOOKUPS FL
194: where resource_id <> l_filter_number1
195: and category like l_aux_value2
196: and resource_number like l_aux_value1
197: and UPPER(resource_name) like l_display_value

Line 365: fnd_lookups flk

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
369: and flk.lookup_type = 'JTF_RS_ROLE_TYPE'

Line 390: fnd_lookups flk

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
394: and flk.lookup_type = 'JTF_RS_ROLE_TYPE'