APPS.JTF_RS_JSP_LOV_RECS_PUB dependencies on JTF_RS_GROUPS_VL

Line 313: from jtf_rs_groups_vl

309: -- Get the total count if "Last" hyperlink is clicked
310: IF (p_range_high < 0) THEN
311: SELECT count(*)
312: INTO l_total_count
313: from jtf_rs_groups_vl
314: where UPPER(group_name) like l_display_value
315: and group_number like l_aux_value1
316: and trunc(sysdate) <= NVL(end_date_active, sysdate)
317: and group_id <> l_filter_number1 ;

Line 334: from jtf_rs_groups_vl

330:
331:
332: OPEN lov_output_cur FOR
333: SELECT group_name, to_char(group_id), group_number, group_desc, null, null, null, null, null, null
334: from jtf_rs_groups_vl
335: where UPPER(group_name) like l_display_value
336: and group_number like l_aux_value1
337: and trunc(sysdate) <= NVL(end_date_active, sysdate)
338: and group_id <> l_filter_number1