APPS.GMD_RECIPE_FETCH_PUB dependencies on GMD_RECIPE_VALIDITY_RULES

Line 41: FROM gmd_recipe_validity_rules

37:
38: /** local cursor to fetch the recipe_id from recipe_validity_rules table **/
39: CURSOR get_recp IS
40: SELECT recipe_id
41: FROM gmd_recipe_validity_rules
42: WHERE recipe_Validity_rule_id = p_recipe_Validity_rule_id ;
43:
44:
45: /*** local Variables ***/

Line 1945: FROM gmd_recipe_validity_rules

1941:
1942: -- Cursor to get recipe_id and organization
1943: CURSOR get_recp_orgn_id IS
1944: SELECT recipe_id, organization_id
1945: FROM gmd_recipe_validity_rules
1946: WHERE recipe_validity_rule_id = p_recipe_validity_rule_id;
1947:
1948: -- Cursor to fetch contiguous indicator at recp-orgn level
1949: CURSOR get_recp_orgn_cont_ind( l_recp_id NUMBER, l_orgn_id NUMBER) IS

Line 2062: FROM gmd_recipe_validity_rules

2058:
2059: -- Cursor to get recipe_id from validity_rule_id
2060: CURSOR get_recp_id IS
2061: SELECT recipe_id
2062: FROM gmd_recipe_validity_rules
2063: WHERE recipe_validity_rule_id = p_recipe_validity_rule_id;
2064:
2065: -- Cursor to fetch enhanced PI flag at recipe level
2066: CURSOR get_pi_flag( l_recp_id NUMBER) IS