APPS.OE_DS_PVT dependencies on OE_MTL_SN_INTERFACE_S

Line 1136: SELECT to_char(oe_mtl_sn_interface_s.nextval)

1132: IF (p_sn_control_code = 6) THEN
1133: IF l_debug_level > 0 THEN
1134: oe_debug_pub.add( 'in for loop s.n control code = 6' , 1 ) ;
1135: END IF;
1136: SELECT to_char(oe_mtl_sn_interface_s.nextval)
1137: INTO v_serial_number_temp
1138: FROM dual ;
1139: IF p_as_alpha_prefix is not null THEN
1140: v_serial_number := p_as_alpha_prefix || v_serial_number_temp;