APPS.JTF_RS_JSP_LOV_RECS_PUB dependencies on JTF_RS_RESOURCE_EXTNS_VL

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 218: from JTF_RS_RESOURCE_EXTNS_VL RES

214: -- Get the total count if "Last" hyperlink is clicked
215: IF (p_range_high < 0) THEN
216: SELECT count(*)
217: INTO l_total_count
218: from JTF_RS_RESOURCE_EXTNS_VL RES
219: where UPPER(resource_name) like l_display_value
220: and res.source_business_grp_id = to_number(l_aux_value2)
221: and trunc(sysdate) <= nvl(res.end_date_active,trunc(sysdate))
222: and res.category = 'EMPLOYEE' ;

Line 247: from JTF_RS_RESOURCE_EXTNS_VL RES

243: null ext_value2,
244: null ext_value3,
245: null ext_value4,
246: null ext_value5
247: from JTF_RS_RESOURCE_EXTNS_VL RES
248: where UPPER(resource_name) like l_display_value
249: and res.source_business_grp_id = to_number(l_aux_value2)
250: and trunc(sysdate) <= nvl(res.end_date_active,trunc(sysdate))
251: and res.category = 'EMPLOYEE'

Line 261: from JTF_RS_RESOURCE_EXTNS_VL RES

257: -- Get the total count if "Last" hyperlink is clicked
258: IF (p_range_high < 0) THEN
259: SELECT count(*)
260: INTO l_total_count
261: from JTF_RS_RESOURCE_EXTNS_VL RES
262: where resource_id <> l_filter_number1
263: and res.source_business_grp_id = to_number(l_aux_value2)
264: and UPPER(resource_name) like l_display_value
265: and trunc(sysdate) <= nvl(res.end_date_active,trunc(sysdate))

Line 291: from JTF_RS_RESOURCE_EXTNS_VL RES

287: null ext_value2,
288: null ext_value3,
289: null ext_value4,
290: null ext_value5
291: from JTF_RS_RESOURCE_EXTNS_VL RES
292: where resource_id <> l_filter_number1
293: and res.source_business_grp_id = to_number(l_aux_value2)
294: and UPPER(resource_name) like l_display_value
295: and trunc(sysdate) <= nvl(res.end_date_active,trunc(sysdate))