DBA Data[Home] [Help]

APPS.OKL_ACTIVATE_CONTRACT_PUB dependencies on OKX_CUST_SITE_USES_V

Line 234: from okx_cust_site_uses_v site_use,

230: --cursor to find BTO status
231: Cursor l_bto_sts_csr(btoid IN NUMBER,
232: custacctid IN NUMBER) is
233: select 'A'
234: from okx_cust_site_uses_v site_use,
235: hz_cust_acct_sites_all site
236: where site_use.id1 = btoid
237: and site_use.site_use_code = 'BILL_TO'
238: and site_use.b_status = 'A'