APPS.GMD_RECIPE_DETAIL dependencies on GMD_RECIPE_VALIDITY_RULES

Line 1685: FROM gmd_recipe_validity_rules

1681: attribute11, attribute12, attribute13, attribute14, attribute15,
1682: attribute16, attribute17, attribute18, attribute19, attribute20,
1683: attribute21, attribute22, attribute23, attribute24,attribute25,
1684: attribute26, attribute27, attribute28, attribute29, attribute30
1685: FROM gmd_recipe_validity_rules
1686: WHERE Recipe_Validity_Rule_id = NVL(vRecipe_VR_id,-1);
1687:
1688:
1689: /* Define a cursor for dealing with updates */

Line 1692: FROM gmd_recipe_validity_rules

1688:
1689: /* Define a cursor for dealing with updates */
1690: CURSOR update_vr_cur(vRecipe_VR_id NUMBER) IS
1691: SELECT recipe_id, orgn_code, end_date, planned_process_loss
1692: FROM gmd_recipe_validity_rules
1693: WHERE Recipe_Validity_Rule_id = NVL(vRecipe_VR_id,-1);
1694:
1695: /* Cursor to get the item id when item no is passed */
1696: CURSOR get_item_id(pItem_no VARCHAR2) IS