DBA Data[Home] [Help]

APPS.AP_BANKACCT_INACTIVE_WF_PKG dependencies on AP_SUPPLIERS

Line 98: l_vendor_id AP_SUPPLIERS.Vendor_Id%TYPE;

94: P_calling_sequence VARCHAR2) RETURN BOOLEAN IS
95:
96: l_party_site_id NUMBER;
97: l_supplier_site_id NUMBER; /* bug 5000194, 4965233 */
98: l_vendor_id AP_SUPPLIERS.Vendor_Id%TYPE;
99: l_vendor_type_lookup_code AP_SUPPLIERS.Vendor_Type_Lookup_Code%TYPE;
100: l_payment_function VARCHAR2(80);
101: l_org_id NUMBER;
102: l_currency_code IBY_EXT_BANK_ACCOUNTS.Currency_Code%TYPE;

Line 99: l_vendor_type_lookup_code AP_SUPPLIERS.Vendor_Type_Lookup_Code%TYPE;

95:
96: l_party_site_id NUMBER;
97: l_supplier_site_id NUMBER; /* bug 5000194, 4965233 */
98: l_vendor_id AP_SUPPLIERS.Vendor_Id%TYPE;
99: l_vendor_type_lookup_code AP_SUPPLIERS.Vendor_Type_Lookup_Code%TYPE;
100: l_payment_function VARCHAR2(80);
101: l_org_id NUMBER;
102: l_currency_code IBY_EXT_BANK_ACCOUNTS.Currency_Code%TYPE;
103: l_extbank_acct_id NUMBER;

Line 156: FROM ap_suppliers

152: SELECT vendor_id,
153: vendor_type_lookup_code
154: INTO l_vendor_id,
155: l_vendor_type_lookup_code
156: FROM ap_suppliers
157: WHERE party_id = p_party_id;
158: EXCEPTION
159: WHEN NO_DATA_FOUND THEN
160: l_debug_info := 'This Payee is not a Supplier';