APPS.JTF_RS_JSP_LOV_RECS_PUB dependencies on DUAL

Line 730: from dual

726: if l_aux_value1 is null then
727:
728: OPEN lov_output_cur FOR
729: select null, null, null, null, null, null, null, null, null, null
730: from dual
731: where 'Y' = 'N';
732: else
733: IF (p_range_high < 0) THEN
734: SELECT count(*)

Line 774: ' from dual '||

770:
771: if l_aux_value1 is null then
772: OPEN lov_output_cur FOR
773: ' select null, null, null, null, null, null, null, null, null, null '||
774: ' from dual '||
775: ' where 1 = 2 ';
776: else
777: IF (p_range_high < 0) THEN
778: EXECUTE IMMEDIATE

Line 857: FROM dual;

853: -- Get the total count if "Last" hyperlink is clicked
854: IF (p_range_high < 0) THEN
855: SELECT count(*)
856: INTO l_total_count
857: FROM dual;
858:
859: l_start := MOD(l_total_count, l_rec_set);
860:
861: IF (l_start = 0) THEN

Line 873: from dual;

869: END IF;
870:
871: OPEN lov_output_cur FOR
872: select 'display_value', 'code_value', 'aux_value1', 'aux_value2', 'aux_value3', null, null, null, null, null
873: from dual;
874: end if;
875:
876: ----------------------------------------------
877: -- Loop dynamic cursor to output table type