APPS.GMD_RECIPE_DETAIL dependencies on GMD_RECIPE_VALIDITY_RULES

Line 1586: FROM gmd_recipe_validity_rules

1582: attribute11, attribute12, attribute13, attribute14, attribute15,
1583: attribute16, attribute17, attribute18, attribute19, attribute20,
1584: attribute21, attribute22, attribute23, attribute24,attribute25,
1585: attribute26, attribute27, attribute28, attribute29, attribute30
1586: FROM gmd_recipe_validity_rules
1587: WHERE Recipe_Validity_Rule_id = NVL(vRecipe_VR_id,-1);
1588:
1589:
1590: /* Define a cursor for dealing with updates */

Line 1593: FROM gmd_recipe_validity_rules

1589:
1590: /* Define a cursor for dealing with updates */
1591: CURSOR update_vr_cur(vRecipe_VR_id NUMBER) IS
1592: SELECT recipe_id, orgn_code, end_date, planned_process_loss
1593: FROM gmd_recipe_validity_rules
1594: WHERE Recipe_Validity_Rule_id = NVL(vRecipe_VR_id,-1);
1595:
1596: /* Cursor to get the item id when item no is passed */
1597: CURSOR get_item_id(pItem_no VARCHAR2) IS