APPS.INV_LOT_SERIAL_DATE_EVENT_PKG dependencies on DUAL

Line 265: SELECT MTL_LOT_NOTIF_ITEM_KEY_S.NEXTVAL INTO l_date_notification_s FROM dual;

261: l_lot_where_clause
262: || ' and mln.lot_attribute_category = :b_attr_context ';
263: END IF;
264: /*Bug#14103573 Adding the sequnce value at the end of the event key*/
265: SELECT MTL_LOT_NOTIF_ITEM_KEY_S.NEXTVAL INTO l_date_notification_s FROM dual;
266: OPEN l_cursor
267: FOR 'select '
268: || l_lot_column_list
269: || ' from '

Line 568: SELECT MTL_LOT_NOTIF_ITEM_KEY_S.NEXTVAL INTO l_date_notification_s FROM dual;

564: l_serial_where_clause
565: || ' and msn.serial_attribute_category = :b_attr_context ';
566: END IF;
567: /*Bug#14103573 Adding the sequnce value at the end of the event key*/
568: SELECT MTL_LOT_NOTIF_ITEM_KEY_S.NEXTVAL INTO l_date_notification_s FROM dual;
569: OPEN l_cursor
570: FOR 'select '
571: || l_serial_column_list
572: || ' from '