DBA Data[Home] [Help]

APPS.OZF_FUNDS_PUB dependencies on ENI_PROD_DEN_HRCHY_PARENTS_V

Line 2065: FROM ENI_PROD_DEN_HRCHY_PARENTS_V

2061: AND concatenated_segments = p_inventory_name;
2062:
2063: CURSOR c_cat_id_exists (p_category_id IN NUMBER) IS
2064: SELECT category_set_id
2065: FROM ENI_PROD_DEN_HRCHY_PARENTS_V
2066: WHERE category_id = p_category_id;
2067:
2068: --08-MAY-2006 kdass bug 5199585 SQL ID# 17778264 - added last condition so that table uses index
2069: CURSOR c_cat_name_exists (p_category_name IN VARCHAR2) IS

Line 2071: FROM ENI_PROD_DEN_HRCHY_PARENTS_V

2067:
2068: --08-MAY-2006 kdass bug 5199585 SQL ID# 17778264 - added last condition so that table uses index
2069: CURSOR c_cat_name_exists (p_category_name IN VARCHAR2) IS
2070: SELECT category_id, category_set_id
2071: FROM ENI_PROD_DEN_HRCHY_PARENTS_V
2072: WHERE category_desc = p_category_name
2073: AND NVL(category_id, 0) = category_id;
2074:
2075: BEGIN