DBA Data[Home] [Help]

APPS.AS_INTEREST_CODES_PUB dependencies on ENI_PROD_DEN_HRCHY_PARENTS_V

Line 128: SELECT 1 FROM ENI_PROD_DEN_HRCHY_PARENTS_V P

124: SELECT as_interest_codes_s.NEXTVAL
125: FROM DUAL;
126:
127: CURSOR prod_category_val_cur(p_prod_cat_set_id IN NUMBER, p_prod_cat_id IN NUMBER) IS
128: SELECT 1 FROM ENI_PROD_DEN_HRCHY_PARENTS_V P
129: WHERE P.CATEGORY_ID = p_prod_cat_id
130: AND P.CATEGORY_SET_ID = p_prod_cat_set_id;
131: l_module CONSTANT VARCHAR2(255) := 'as.plsql.intc.create_interest_code';
132:

Line 784: SELECT 1 FROM ENI_PROD_DEN_HRCHY_PARENTS_V P

780: FROM as_interest_codes_vl
781: WHERE interest_code_id = p_interest_code_id;
782:
783: CURSOR prod_category_val_cur(p_prod_cat_set_id IN NUMBER, p_prod_cat_id IN NUMBER) IS
784: SELECT 1 FROM ENI_PROD_DEN_HRCHY_PARENTS_V P
785: WHERE P.CATEGORY_ID = p_prod_cat_id
786: AND P.CATEGORY_SET_ID = p_prod_cat_set_id;
787: l_module CONSTANT VARCHAR2(255) := 'as.plsql.intc.update_interest_code';
788: