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 2104: FROM DUAL;

2100:
2101:
2102: SELECT OE_SETS_S.NEXTVAL
2103: INTO l_set_id
2104: FROM DUAL;
2105: IF l_debug_level > 0 THEN
2106: oe_debug_pub.add( 'AFTERSEQUECEVALUE ' , 1 ) ;
2107: END IF;
2108: IF g_cust_pref_set AND (p_set_type = 'SHIP_SET'

Line 5256: FROM DUAL;

5252: END IF;
5253:
5254: SELECT OE_SETS_S.NEXTVAL
5255: INTO l_set_id
5256: FROM DUAL;
5257: IF l_debug_level > 0 THEN
5258: oe_debug_pub.add( 'AFTERSEQUECEVALUE ' , 1 ) ;
5259: END IF;
5260: INSERT INTO OE_SETS(