APPS.GMI_LOCT_INV_PVT dependencies on GMA_GLOBAL_GRP

Line 171: GMA_GLOBAL_GRP.SY$MAX_DATE, p_tran_rec.trans_date + nvl(shelf_life,0))),

167: update ic_lots_mst
168: set (lot_created, expire_date, retest_date, expaction_date) =
169: ( select nvl(lot_created, p_tran_rec.trans_date),
170: nvl(expire_date, decode (grade_ctl + nvl(shelf_life,0), 0,
171: GMA_GLOBAL_GRP.SY$MAX_DATE, p_tran_rec.trans_date + nvl(shelf_life,0))),
172: nvl(retest_date, decode (grade_ctl + nvl(shelf_life,0), 0,
173: GMA_GLOBAL_GRP.SY$MAX_DATE, p_tran_rec.trans_date + nvl(retest_interval,0))),
174: nvl(expaction_date, decode (grade_ctl + nvl(shelf_life,0), 0,
175: GMA_GLOBAL_GRP.SY$MAX_DATE, p_tran_rec.trans_date + nvl(shelf_life,0) +

Line 173: GMA_GLOBAL_GRP.SY$MAX_DATE, p_tran_rec.trans_date + nvl(retest_interval,0))),

169: ( select nvl(lot_created, p_tran_rec.trans_date),
170: nvl(expire_date, decode (grade_ctl + nvl(shelf_life,0), 0,
171: GMA_GLOBAL_GRP.SY$MAX_DATE, p_tran_rec.trans_date + nvl(shelf_life,0))),
172: nvl(retest_date, decode (grade_ctl + nvl(shelf_life,0), 0,
173: GMA_GLOBAL_GRP.SY$MAX_DATE, p_tran_rec.trans_date + nvl(retest_interval,0))),
174: nvl(expaction_date, decode (grade_ctl + nvl(shelf_life,0), 0,
175: GMA_GLOBAL_GRP.SY$MAX_DATE, p_tran_rec.trans_date + nvl(shelf_life,0) +
176: nvl(expaction_interval,0)))
177: from ic_item_mst_b

Line 175: GMA_GLOBAL_GRP.SY$MAX_DATE, p_tran_rec.trans_date + nvl(shelf_life,0) +

171: GMA_GLOBAL_GRP.SY$MAX_DATE, p_tran_rec.trans_date + nvl(shelf_life,0))),
172: nvl(retest_date, decode (grade_ctl + nvl(shelf_life,0), 0,
173: GMA_GLOBAL_GRP.SY$MAX_DATE, p_tran_rec.trans_date + nvl(retest_interval,0))),
174: nvl(expaction_date, decode (grade_ctl + nvl(shelf_life,0), 0,
175: GMA_GLOBAL_GRP.SY$MAX_DATE, p_tran_rec.trans_date + nvl(shelf_life,0) +
176: nvl(expaction_interval,0)))
177: from ic_item_mst_b
178: where item_id = l_loct_inv.item_id)
179: Where item_id = l_loct_inv.item_id and