DBA Data[Home] [Help]

APPS.OKL_QA_DATA_INTEGRITY dependencies on OKX_RCPT_METHOD_ACCOUNTS_V

Line 9676: FROM okx_rcpt_method_accounts_v okx_custbkac

9672: CURSOR bank_acct_csr(p_cust_acct_id IN NUMBER,
9673: p_bill_to_id IN NUMBER,
9674: p_bank_acct_id IN NUMBER) IS
9675: SELECT 'Y'
9676: FROM okx_rcpt_method_accounts_v okx_custbkac
9677: WHERE SYSDATE < NVL(end_date_active,SYSDATE+1)
9678: AND customer_id = p_cust_acct_id
9679: --For bug 8325912 AND customer_site_use_id = p_bill_to_id
9680: AND id1 = p_bank_acct_id;

Line 10425: FROM okx_rcpt_method_accounts_v okx_custbkac

10421: CURSOR bank_acct_csr(p_cust_acct_id IN NUMBER,
10422: p_bill_to_id IN NUMBER,
10423: p_bank_acct_id IN NUMBER) IS
10424: SELECT 'Y'
10425: FROM okx_rcpt_method_accounts_v okx_custbkac
10426: WHERE SYSDATE < NVL(end_date_active,SYSDATE+1)
10427: AND customer_id = p_cust_acct_id
10428: --For bug 8325912 AND customer_site_use_id = p_bill_to_id
10429: AND id1 = p_bank_acct_id;