APPS.GMD_QC_LABELS_UTIL dependencies on GMP_RESOURCE_INSTANCES

Line 246: FROM GMP_RESOURCE_INSTANCES a, GMD_SS_VARIANTS B

242: -- changed storage_location to storage_locator_id.
243:
244: CURSOR c_get_variant_storage IS
245: SELECT a.instance_number, b.resources, b.storage_organization_id, b.storage_subinventory, b.storage_locator_id
246: FROM GMP_RESOURCE_INSTANCES a, GMD_SS_VARIANTS B
247: WHERE a.INSTANCE_ID(+) = b.resource_instance_id
248: AND b.variant_id = p_variant_id;
249: c_variant_storage_row c_get_variant_storage%ROWTYPE;
250: