APPS.AS_INTEREST_CODES_PUB dependencies on AS_INTEREST_TYPES_VL

Line 104: FROM as_interest_types_vl

100:
101:
102: CURSOR as_int_type_cur(p_interest_type_id IN NUMBER) IS
103: SELECT 1
104: FROM as_interest_types_vl
105: WHERE interest_type_id = p_interest_type_id
106: AND interest_type_id IS NOT NULL;
107:
108:

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);