APPS.AS_INTEREST_TYPES_PUB dependencies on DUAL

Line 84: FROM DUAL;

80: WHERE TRIM(NLS_UPPER(interest_type)) = p_interest_type; -- passing in trimmed value while opening.
81:
82: CURSOR interest_id_cur IS
83: SELECT as_interest_types_s.NEXTVAL
84: FROM DUAL;
85:
86: CURSOR prod_category_val_cur(p_prod_cat_set_id IN NUMBER, p_prod_cat_id IN NUMBER) IS
87: SELECT 1 FROM ENI_PROD_DEN_HRCHY_PARENTS_V P
88: WHERE P.CATEGORY_ID = p_prod_cat_id