APPS.OKL_DEAL_CREAT_PVT dependencies on OKX_CUST_SITE_USES_V

Line 8411: FROM okx_cust_site_uses_v cust_site

8407: AND rgp.chr_id = p_durv_rec.chr_id;
8408:
8409: CURSOR l_legal_address_csr(p_cust_id1 VARCHAR2) IS
8410: SELECT cust_site.description
8411: FROM okx_cust_site_uses_v cust_site
8412: WHERE cust_site.party_id = p_cust_id1
8413: AND cust_site.site_use_code = 'LEGAL'
8414: and cust_site.status='A' -- Bug 10373290
8415: and cust_site.b_status='A';

Line 9080: FROM okx_cust_site_uses_v cust_site

9076: --start| 27-Jun-2008 cklee Bug 6957971 |
9077: /*cklee 06/27/08
9078: CURSOR c_legal_address(p_party_id NUMBER) IS
9079: SELECT cust_site.description
9080: FROM okx_cust_site_uses_v cust_site
9081: WHERE cust_site.party_id = p_party_id
9082: AND cust_site.site_use_code = 'LEGAL';
9083: */
9084: -- Each account may have one primary legal address (purpose = Legal)

Line 9091: FROM okx_cust_site_uses_v cust_site

9087: -- legal address for the account
9088: --Bug# 12425605
9089: CURSOR c_legal_address(p_party_id NUMBER, cp_cust_acct_id NUMBER) IS
9090: SELECT SUBSTR(cust_site.description,1,2000) description
9091: FROM okx_cust_site_uses_v cust_site
9092: WHERE cust_site.party_id = p_party_id
9093: AND cust_site.cust_account_id = cp_cust_acct_id
9094: AND cust_site.site_use_code = 'LEGAL'
9095: and cust_site.status='A' -- Bug 10373290