DBA Data[Home] [Help]

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