APPS.AS_INTEREST_PUB dependencies on AS_INTEREST_CODES_V

Line 703: FROM as_interest_codes_v

699: interest_type like lower(substr(X_Int_Type, 1, 1) || '%'));
700:
701: Cursor C_Get_Int_Code (X_Int_Code VARCHAR2, X_Int_Type_Id NUMBER) IS
702: SELECT interest_code_id
703: FROM as_interest_codes_v
704: WHERE nls_upper(X_Int_Code) = nls_upper(code)
705: and interest_type_id = X_Int_Type_Id;
706:
707:

Line 711: FROM as_interest_codes_v

707:
708: CURSOR interest_code_desc( p_interest_code_id number
709: ,p_interest_type_id number) IS
710: SELECT description
711: FROM as_interest_codes_v
712: WHERE interest_code_id = p_interest_code_id
713: and interest_type_id = p_interest_type_id;
714:
715: CURSOR interest_type_desc(p_interest_type_id number) IS