DBA Data[Home] [Help]

APPS.AS_INTEREST_CODES_PUB dependencies on DUAL

Line 125: FROM DUAL;

121: AND parent_interest_code_id = p_parent_interest_code_id ;
122:
123: CURSOR as_int_code_nextval_cur IS
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