APPS.PMI_LOT_GENEALOGY_PKG dependencies on IC_LOTS_MST

Line 208: FROM ic_lots_mst

204: PROCEDURE add_lot_self_genealogy(pp_last_refresh_date DATE, pp_current_refresh_date DATE)
205: IS
206: CURSOR new_lots IS
207: SELECT item_id, lot_id
208: FROM ic_lots_mst
209: WHERE lot_id <> 0
210: AND creation_date BETWEEN NVL(pp_last_refresh_date, creation_date) AND pp_current_refresh_date;
211: BEGIN
212: FOR nl IN new_lots