APPS.GMD_AUTO_SAMPLE_PKG dependencies on GMD_SAMPLING_PLANS_B

Line 45: from gmd_sampling_plans_b sm

41: nvl(ARCHIVE_CNT_REQ,0) archive_cnt_req,
42: nvl(sample_qty, 0) sample_qty, sample_qty_uom,
43: nvl(RESERVE_QTY, 0) reserve_qty,
44: nvl(ARCHIVE_QTY,0) archive_qty
45: from gmd_sampling_plans_b sm
46: where sm.sampling_plan_id = x_sampling_plan_id ;
47:
48: -- bug 4924526 SQL Id 14689707 - fix this 13,582,446 shared memory FTS -
49: cursor get_vr_info (x_spec_vr_id number) is