APPS.AS_INTEREST_PUB dependencies on AS_INTEREST_TYPES_VL

Line 696: FROM as_interest_types_vl

692: p_out_description OUT NOCOPY VARCHAR2
693: ) IS
694: Cursor C_Get_Int_Type (X_Int_Type VARCHAR2) IS
695: SELECT interest_type_id
696: FROM as_interest_types_vl
697: WHERE nls_upper(X_Int_Type) = nls_upper(interest_type)
698: and (interest_type like nls_upper(substr(X_Int_Type, 1, 1) || '%') or
699: interest_type like lower(substr(X_Int_Type, 1, 1) || '%'));
700:

Line 717: FROM as_interest_types_vl

713: and interest_type_id = p_interest_type_id;
714:
715: CURSOR interest_type_desc(p_interest_type_id number) IS
716: SELECT description
717: FROM as_interest_types_vl
718: WHERE interest_type_id = p_interest_type_id;
719:
720: l_description varchar2(255);
721: l_interest_type_id NUMBER;