3082: ,lkup.meaning sty_subclass_meaning
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
3279: CURSOR l_okl_reject_codes_csr
3280: IS
3281: SELECT lookup_code,
3282: meaning
3283: FROM fnd_lookups
3284: WHERE LOOKUP_TYPE LIKE 'OKL_POOL_REJECT_REASON'
3285: ORDER BY LOOKUP_CODE;
3286:
3287: /* sosharma 21-nov-2007