APPS.IGI_BUD dependencies on DUAL

Line 14: FROM sys.dual

10: l_char VARCHAR2(1);
11: BEGIN
12: SELECT 'x'
13: INTO l_char
14: FROM sys.dual
15: WHERE TO_CHAR(TO_NUMBER(p_char)) = p_char;
16:
17: RETURN 1;
18:

Line 466: FROM dual;

462: decode(p_table_alias,null,null,
463: p_table_alias||'.')||
464: segment.APPLICATION_COLUMN_NAME
465: INTO where_list
466: FROM dual;
467:
468: r_where_list := r_where_list||where_list;
469: END LOOP;
470:

Line 518: FROM dual;

514: decode(p_table_alias,null,null,
515: p_table_alias||'.')||
516: segment.APPLICATION_COLUMN_NAME
517: INTO where_list
518: FROM dual;
519:
520: r_where_list := r_where_list||where_list;
521: END LOOP;
522: RETURN (r_where_list);

Line 574: FROM dual;

570: decode(p_range_table_alias,null,null,
571: p_range_table_alias||'.')||
572: segment.APPLICATION_COLUMN_NAME||'_HIGH'
573: INTO where_list
574: FROM dual;
575:
576: r_where_list := r_where_list||where_list;
577: END LOOP;
578: RETURN (r_where_list);

Line 750: FROM sys.dual

746:
747: BEGIN
748: SELECT NULL
749: INTO l_line_reference_3
750: FROM sys.dual
751: WHERE line.reference_3 <> 'MANUAL'
752: AND line.reference_3 is not null
753: AND line.reference_3 not in (
754: SELECT profile_code