DBA Data[Home] [Help]

APPS.OKL_POOL_PVT dependencies on HZ_CUSTOMER_PROFILES

Line 3087: ,hz_customer_profiles hcp

3083: ,pol.asset_number
3084: ,hcp.credit_classification
3085: FROM okl_pool_srch_v pol
3086: ,fnd_lookups lkup
3087: ,hz_customer_profiles hcp
3088: ,okl_strm_type_b strm -- added for bug 13997160 :vsgandhi
3089: WHERE
3090: -- pre-req
3091: pol.currency_code = p_currency_code

Line 3882: ,hz_customer_profiles hcp

3878: -- mvasudev, 09/28/2004, Bug#3909240
3879: ,pocv.stream_type_purpose
3880: ,hcp.credit_classification
3881: FROM okl_pool_contents_uv pocv
3882: ,hz_customer_profiles hcp
3883: -- pool_number
3884: WHERE pocv.pol_id = p_pol_id
3885: -- customer
3886: AND NVL(pocv.cust_object1_id1,G_DEFAULT_NUM) = NVL(p_cust_object1_id1, NVL(pocv.cust_object1_id1,G_DEFAULT_NUM))