DBA Data[Home] [Help]

APPS.JTF_RS_JSP_LOV_RECS_PUB dependencies on JTF_RS_PLATFORMS_V

Line 628: from jtf_rs_platforms_v a

624: -- Get the total count if "Last" hyperlink is clicked
625: IF (p_range_high < 0) THEN
626: SELECT count(*)
627: INTO l_total_count
628: from jtf_rs_platforms_v a
629: where UPPER(a.PLATFORM_NAME) like l_display_value
630: and a.platform_org_id = l_org_id;
631:
632: l_start := MOD(l_total_count, l_rec_set);

Line 646: from jtf_rs_platforms_v a

642: END IF;
643:
644: OPEN lov_output_cur FOR
645: select a.PLATFORM_NAME, to_char(a.PLATFORM_ID), to_char(a.category_id), a.DESCRIPTION, null, null, null, null, null, null
646: from jtf_rs_platforms_v a
647: where UPPER(a.PLATFORM_NAME) like l_display_value
648: and a.platform_org_id = l_org_id
649: order by a.PLATFORM_NAME;
650: else

Line 655: from jtf_rs_platforms_v a

651: -- Get the total count if "Last" hyperlink is clicked
652: IF (p_range_high < 0) THEN
653: SELECT count(*)
654: INTO l_total_count
655: from jtf_rs_platforms_v a
656: where UPPER(a.PLATFORM_NAME) like l_display_value
657: and a.category_id = l_aux_value1
658: and a.platform_org_id = l_org_id;
659:

Line 674: from jtf_rs_platforms_v a

670: END IF;
671:
672: OPEN lov_output_cur FOR
673: select a.PLATFORM_NAME, to_char(a.PLATFORM_ID), to_char(a.category_id), a.DESCRIPTION, null, null, null, null, null, null
674: from jtf_rs_platforms_v a
675: where UPPER(a.PLATFORM_NAME) like l_display_value
676: and a.category_id = l_aux_value1
677: and a.platform_org_id = l_org_id
678: order by a.PLATFORM_NAME;