DBA Data[Home] [Help]

APPS.GMD_FORMULA_DETAIL_PUB dependencies on GMD_RECIPE_VALIDITY_RULES

Line 1585: gmd_recipe_validity_rules vr,

1581:
1582: CURSOR check_validity_rules(pformula_id number, pitem_no varchar2 ) IS
1583: SELECT 1
1584: FROM gmd_recipes_b rcp,
1585: gmd_recipe_validity_rules vr,
1586: ic_item_mst it
1587: WHERE vr.delete_mark = 0
1588: AND vr.validity_rule_status < 1000
1589: AND (vr.end_date IS NULL OR vr.end_date >= SYSDATE)