DBA Data[Home] [Help]

APPS.OKL_ACTIVATE_CONTRACT_PUB dependencies on OKX_CUST_SITE_USES_V

Line 516: from okx_cust_site_uses_v site_use,

512: --cursor to find BTO status
513: Cursor l_bto_sts_csr(btoid IN NUMBER,
514: custacctid IN NUMBER) is
515: select 'A'
516: from okx_cust_site_uses_v site_use,
517: hz_cust_acct_sites_all site
518: where site_use.id1 = btoid
519: and site_use.site_use_code = 'BILL_TO'
520: and site_use.b_status = 'A'