DBA Data[Home] [Help]

APPS.OZF_FUNDS_PUB dependencies on ENI_PROD_DEN_HRCHY_PARENTS_V

Line 2035: FROM ENI_PROD_DEN_HRCHY_PARENTS_V

2031: AND concatenated_segments = p_inventory_name;
2032:
2033: CURSOR c_cat_id_exists (p_category_id IN NUMBER) IS
2034: SELECT category_set_id
2035: FROM ENI_PROD_DEN_HRCHY_PARENTS_V
2036: WHERE category_id = p_category_id;
2037:
2038: --08-MAY-2006 kdass bug 5199585 SQL ID# 17778264 - added last condition so that table uses index
2039: CURSOR c_cat_name_exists (p_category_name IN VARCHAR2) IS

Line 2041: FROM ENI_PROD_DEN_HRCHY_PARENTS_V

2037:
2038: --08-MAY-2006 kdass bug 5199585 SQL ID# 17778264 - added last condition so that table uses index
2039: CURSOR c_cat_name_exists (p_category_name IN VARCHAR2) IS
2040: SELECT category_id, category_set_id
2041: FROM ENI_PROD_DEN_HRCHY_PARENTS_V
2042: WHERE category_desc = p_category_name
2043: AND NVL(category_id, 0) = category_id;
2044:
2045: BEGIN