APPS.AS_INTEREST_TYPES_PUB dependencies on AS_INTEREST_TYPES_S
Line 83: SELECT as_interest_types_s.NEXTVAL
79: FROM as_interest_types_vl
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