APPS.OKL_DEAL_CREAT_PVT dependencies on OKX_CUST_SITE_USES_V

Line 8337: FROM okx_cust_site_uses_v cust_site

8333: AND rgp.chr_id = p_durv_rec.chr_id;
8334:
8335: CURSOR l_legal_address_csr(p_cust_id1 VARCHAR2) IS
8336: SELECT cust_site.description
8337: FROM okx_cust_site_uses_v cust_site
8338: WHERE cust_site.party_id = p_cust_id1
8339: AND cust_site.site_use_code = 'LEGAL';
8340:
8341: CURSOR l_product_csr(product_id NUMBER) IS

Line 8988: FROM okx_cust_site_uses_v cust_site

8984: --start| 27-Jun-2008 cklee Bug 6957971 |
8985: /*cklee 06/27/08
8986: CURSOR c_legal_address(p_party_id NUMBER) IS
8987: SELECT cust_site.description
8988: FROM okx_cust_site_uses_v cust_site
8989: WHERE cust_site.party_id = p_party_id
8990: AND cust_site.site_use_code = 'LEGAL';
8991: */
8992: -- Each account may have one primary legal address (purpose = Legal)

Line 8998: FROM okx_cust_site_uses_v cust_site

8994: -- to add additional cust_account_id as a key to retrieve specific
8995: -- legal address for the account
8996: CURSOR c_legal_address(p_party_id NUMBER, cp_cust_acct_id NUMBER) IS
8997: SELECT cust_site.description
8998: FROM okx_cust_site_uses_v cust_site
8999: WHERE cust_site.party_id = p_party_id
9000: AND cust_site.cust_account_id = cp_cust_acct_id
9001: AND cust_site.site_use_code = 'LEGAL';
9002: --end| 27-Jun-2008 cklee Bug 6957971 |