DBA Data[Home] [Help]

APPS.OKL_QA_DATA_INTEGRITY dependencies on OKX_RCPT_METHOD_ACCOUNTS_V

Line 9255: FROM okx_rcpt_method_accounts_v okx_custbkac

9251: CURSOR bank_acct_csr(p_cust_acct_id IN NUMBER,
9252: p_bill_to_id IN NUMBER,
9253: p_bank_acct_id IN NUMBER) IS
9254: SELECT 'Y'
9255: FROM okx_rcpt_method_accounts_v okx_custbkac
9256: WHERE SYSDATE < NVL(end_date_active,SYSDATE+1)
9257: AND customer_id = p_cust_acct_id
9258: AND customer_site_use_id = p_bill_to_id
9259: AND id1 = p_bank_acct_id;

Line 10004: FROM okx_rcpt_method_accounts_v okx_custbkac

10000: CURSOR bank_acct_csr(p_cust_acct_id IN NUMBER,
10001: p_bill_to_id IN NUMBER,
10002: p_bank_acct_id IN NUMBER) IS
10003: SELECT 'Y'
10004: FROM okx_rcpt_method_accounts_v okx_custbkac
10005: WHERE SYSDATE < NVL(end_date_active,SYSDATE+1)
10006: AND customer_id = p_cust_acct_id
10007: AND customer_site_use_id = p_bill_to_id
10008: AND id1 = p_bank_acct_id;