APPS.AS_INTEREST_CODES_PUB dependencies on AS_INTEREST_CODES_VL

Line 97: FROM as_interest_codes_vl

93: l_prod_cat_not_found VARCHAR2(1) := 'N';
94:
95: CURSOR as_int_code_cur(p_parent_interest_code_id IN NUMBER) IS
96: SELECT 1
97: FROM as_interest_codes_vl
98: WHERE interest_code_id = p_parent_interest_code_id
99: AND interest_code_id IS NOT NULL;
100:
101:

Line 111: FROM as_interest_codes_vl

107:
108:
109: CURSOR as_int_codes_vl_cur(p_code IN VARCHAR2,p_interest_type_id IN NUMBER) IS
110: SELECT 1
111: FROM as_interest_codes_vl
112: WHERE TRIM(NLS_UPPER(code)) = p_code -- passing in trimmed value while opening.
113: AND interest_type_id = p_interest_type_id
114: AND parent_interest_code_id IS NULL ;
115:

Line 118: FROM as_interest_codes_vl

114: AND parent_interest_code_id IS NULL ;
115:
116: CURSOR as_int_codes_vl_1_cur(p_code IN VARCHAR2,p_interest_type_id IN NUMBER,p_parent_interest_code_id IN NUMBER) IS
117: SELECT 1
118: FROM as_interest_codes_vl
119: WHERE TRIM(NLS_UPPER(code)) = p_code -- passing in trimmed value while opening.
120: AND interest_type_id = p_interest_type_id
121: AND parent_interest_code_id = p_parent_interest_code_id ;
122:

Line 424: -- as_interest_types_vl and as_interest_codes_vl respectively

420: -- End of all optional fields check for g_miss
421:
422:
423: -- Check if Interest Type ID and Parent Interest Code ID exist in
424: -- as_interest_types_vl and as_interest_codes_vl respectively
425:
426: IF (l_parent_interest_code_id IS NOT NULL)
427: THEN
428: OPEN as_int_code_cur(p_interest_code_rec.parent_interest_code_id);

Line 747: FROM AS_INTEREST_CODES_vl

743: last_updated_by,
744: last_update_login,
745: product_cat_set_id,
746: product_category_id
747: FROM AS_INTEREST_CODES_vl
748: WHERE interest_code_id = p_interest_code_id;
749:
750: CURSOR validate_interest_type_cur(p_interest_type_id IN NUMBER) IS
751: SELECT 1

Line 764: FROM as_interest_codes_vl

760: AND INTEREST_CODE_ID IS NOT NULL;
761:
762: CURSOR as_int_codes_vl_cur(p_interest_code_id IN NUMBER, p_code IN VARCHAR2,p_interest_type_id IN NUMBER) IS
763: SELECT 1
764: FROM as_interest_codes_vl
765: WHERE interest_code_id <> p_interest_code_id
766: AND TRIM(NLS_UPPER(code)) = p_code ---- -- passing in trimmed value while opening.
767: AND interest_type_id = p_interest_type_id
768: AND parent_interest_code_id IS NULL ;

Line 772: FROM as_interest_codes_vl

768: AND parent_interest_code_id IS NULL ;
769:
770: CURSOR as_int_codes_vl_1_cur(p_interest_code_id IN NUMBER, p_code IN VARCHAR2,p_interest_type_id IN NUMBER,p_parent_interest_code_id IN NUMBER) IS
771: SELECT 1
772: FROM as_interest_codes_vl
773: WHERE interest_code_id <> p_interest_code_id
774: AND TRIM(NLS_UPPER(code)) = p_code ----- -- passing in trimmed value while opening.
775: AND interest_type_id = p_interest_type_id
776: AND parent_interest_code_id = p_parent_interest_code_id ;

Line 780: FROM as_interest_codes_vl

776: AND parent_interest_code_id = p_parent_interest_code_id ;
777:
778: CURSOR lock_row_for_update(p_interest_code_id in number) IS
779: SELECT last_update_date
780: FROM as_interest_codes_vl
781: WHERE interest_code_id = p_interest_code_id;
782:
783: CURSOR prod_category_val_cur(p_prod_cat_set_id IN NUMBER, p_prod_cat_id IN NUMBER) IS
784: SELECT 1 FROM ENI_PROD_DEN_HRCHY_PARENTS_V P