DBA Data[Home] [Help]

APPS.OE_SET_UTIL dependencies on DUAL

Line 72: from dual

68:
69: -- 4236316 start
70: select 1
71: into lcount
72: from dual
73: where exists (select 1
74: from oe_line_sets
75: where set_id = p_set_id
76: and line_id = p_line_id);

Line 2051: FROM DUAL;

2047:
2048:
2049: SELECT OE_SETS_S.NEXTVAL
2050: INTO l_set_id
2051: FROM DUAL;
2052: IF l_debug_level > 0 THEN
2053: oe_debug_pub.add( 'AFTERSEQUECEVALUE ' , 1 ) ;
2054: END IF;
2055: IF g_cust_pref_set AND (p_set_type = 'SHIP_SET'

Line 5199: FROM DUAL;

5195: END IF;
5196:
5197: SELECT OE_SETS_S.NEXTVAL
5198: INTO l_set_id
5199: FROM DUAL;
5200: IF l_debug_level > 0 THEN
5201: oe_debug_pub.add( 'AFTERSEQUECEVALUE ' , 1 ) ;
5202: END IF;
5203: INSERT INTO OE_SETS(