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 1884: FROM gmd_recipe_validity_rules

1880:
1881: -- Cursor to get recipe_id and organization
1882: CURSOR get_recp_orgn_id IS
1883: SELECT recipe_id, organization_id
1884: FROM gmd_recipe_validity_rules
1885: WHERE recipe_validity_rule_id = p_recipe_validity_rule_id;
1886:
1887: -- Cursor to fetch contiguous indicator at recp-orgn level
1888: CURSOR get_recp_orgn_cont_ind( l_recp_id NUMBER, l_orgn_id NUMBER) IS

Line 2001: FROM gmd_recipe_validity_rules

1997:
1998: -- Cursor to get recipe_id from validity_rule_id
1999: CURSOR get_recp_id IS
2000: SELECT recipe_id
2001: FROM gmd_recipe_validity_rules
2002: WHERE recipe_validity_rule_id = p_recipe_validity_rule_id;
2003:
2004: -- Cursor to fetch enhanced PI flag at recipe level
2005: CURSOR get_pi_flag( l_recp_id NUMBER) IS