APPS.AS_INTEREST_TYPES_PUB dependencies on AS_INTEREST_TYPES_VL

Line 79: FROM as_interest_types_vl

75: l_prod_cat_not_found VARCHAR2(1) := 'N';
76:
77: CURSOR interest_dup_cur(p_interest_type IN VARCHAR2) IS
78: SELECT 1
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

Line 499: FROM as_interest_types_vl

495: last_updated_by,
496: last_update_login,
497: product_cat_set_id,
498: product_category_id
499: FROM as_interest_types_vl
500: WHERE interest_type_id = p_interest_type_id;
501:
502: CURSOR as_int_type_cur(p_interest_type_id IN NUMBER,p_interest_type IN VARCHAR2) IS
503: SELECT 1

Line 504: FROM as_interest_types_vl

500: WHERE interest_type_id = p_interest_type_id;
501:
502: CURSOR as_int_type_cur(p_interest_type_id IN NUMBER,p_interest_type IN VARCHAR2) IS
503: SELECT 1
504: FROM as_interest_types_vl
505: WHERE interest_type_id <> p_interest_type_id
506: AND TRIM(NLS_UPPER(interest_type)) = p_interest_type;
507:
508:

Line 511: FROM as_interest_types_vl

507:
508:
509: CURSOR lock_row_for_update( p_interest_type_id in NUMBER) IS
510: SELECT last_update_date
511: FROM as_interest_types_vl
512: WHERE interest_type_id = p_interest_type_id;
513:
514: CURSOR prod_category_val_cur(p_prod_cat_set_id IN NUMBER, p_prod_cat_id IN NUMBER) IS
515: SELECT 1 FROM ENI_PROD_DEN_HRCHY_PARENTS_V P