APPS.GME_RELEASE_BATCH_STEP_PVT dependencies on GME_MATERIAL_DETAILS

Line 645: FROM gme_material_details matl, gme_batch_step_items item

641: IS
642: CURSOR cur_step_ingredients (v_batchstep_id NUMBER)
643: IS
644: SELECT matl.*
645: FROM gme_material_details matl, gme_batch_step_items item
646: WHERE item.batchstep_id = v_batchstep_id
647: AND item.material_detail_id = matl.material_detail_id
648: AND matl.line_type = gme_common_pvt.g_line_type_ing
649: AND matl.release_type = gme_common_pvt.g_mtl_autobystep_release;

Line 653: l_matl_dtl_rec gme_material_details%ROWTYPE;

649: AND matl.release_type = gme_common_pvt.g_mtl_autobystep_release;
650:
651: l_api_name CONSTANT VARCHAR2 (30) := 'release_step_ingredients';
652: l_return_status VARCHAR2 (1);
653: l_matl_dtl_rec gme_material_details%ROWTYPE;
654: l_matl_dtl_tab gme_common_pvt.material_details_tab;
655: l_consume BOOLEAN;
656: error_process_ing EXCEPTION;
657: BEGIN