APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKX_RCPT_METHOD_ACCOUNTS_V

Line 4649: FROM okx_rcpt_method_accounts_v

4645: p_customer_acc_id NUMBER,
4646: p_cust_site_id NUMBER,
4647: p_org_id NUMBER) IS
4648: SELECT id1
4649: FROM okx_rcpt_method_accounts_v
4650: WHERE (
4651: (bank_account_num = p_bank_acc_number)
4652: OR
4653: (id1 = p_bank_acc_id)

Line 4669: l_id OKX_RCPT_METHOD_ACCOUNTS_V.ID1%TYPE;

4665: -- udhenuko Bug#5925603 : added order clause so that one used at site level will take precedence
4666: ORDER BY CUSTOMER_SITE_USE_ID;
4667: --Bug#5925603 : End
4668:
4669: l_id OKX_RCPT_METHOD_ACCOUNTS_V.ID1%TYPE;
4670: bank_acct_failed EXCEPTION;
4671: l_proc_name VARCHAR2(35) := 'GET_BANK_ACCOUNT_ID';
4672:
4673: BEGIN

Line 7916: x_bank_account_id OKX_RCPT_METHOD_ACCOUNTS_V.ID1%TYPE;

7912: l_proc_name VARCHAR2(35) := 'CREATE_HEADER_RULES';
7913:
7914: x_customer_account_id OKX_CUSTOMER_ACCOUNTS_V.ID1%TYPE;
7915: x_bill_to_address_id OKX_CUST_SITE_USES_V.ID1%TYPE;
7916: x_bank_account_id OKX_RCPT_METHOD_ACCOUNTS_V.ID1%TYPE;
7917: x_invoice_format_id OKL_INVOICE_FORMATS_V.ID%TYPE;
7918: x_payment_method_id OKX_RECEIPT_METHODS_V.ID1%TYPE;
7919: x_invoice_format_name okl_invoice_formats_v.name%TYPE;
7920: x_index_id okl_indices.id%TYPE;