APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKX_RCPT_METHOD_ACCOUNTS_V

Line 4481: FROM okx_rcpt_method_accounts_v

4477: p_customer_acc_id NUMBER,
4478: p_cust_site_id NUMBER,
4479: p_org_id NUMBER) IS
4480: SELECT id1
4481: FROM okx_rcpt_method_accounts_v
4482: WHERE (
4483: (bank_account_num = p_bank_acc_number)
4484: OR
4485: (id1 = p_bank_acc_id)

Line 4501: l_id OKX_RCPT_METHOD_ACCOUNTS_V.ID1%TYPE;

4497: -- udhenuko Bug#5925603 : added order clause so that one used at site level will take precedence
4498: ORDER BY CUSTOMER_SITE_USE_ID;
4499: --Bug#5925603 : End
4500:
4501: l_id OKX_RCPT_METHOD_ACCOUNTS_V.ID1%TYPE;
4502: bank_acct_failed EXCEPTION;
4503: l_proc_name VARCHAR2(35) := 'GET_BANK_ACCOUNT_ID';
4504:
4505: BEGIN

Line 7748: x_bank_account_id OKX_RCPT_METHOD_ACCOUNTS_V.ID1%TYPE;

7744: l_proc_name VARCHAR2(35) := 'CREATE_HEADER_RULES';
7745:
7746: x_customer_account_id OKX_CUSTOMER_ACCOUNTS_V.ID1%TYPE;
7747: x_bill_to_address_id OKX_CUST_SITE_USES_V.ID1%TYPE;
7748: x_bank_account_id OKX_RCPT_METHOD_ACCOUNTS_V.ID1%TYPE;
7749: x_invoice_format_id OKL_INVOICE_FORMATS_V.ID%TYPE;
7750: x_payment_method_id OKX_RECEIPT_METHODS_V.ID1%TYPE;
7751: x_invoice_format_name okl_invoice_formats_v.name%TYPE;
7752: x_index_id okl_indices.id%TYPE;