APPS.OKL_TXL_ASSETS_PVT dependencies on OKL_PROD_QLTY_VAL_UV

Line 121: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v

117: and khr.id = p_chr_id;
118:
119: l_deal_type_rec l_deal_type_csr%ROWTYPE;
120:
121: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
122: --cursor to get deal type corresponding to a product
123: Cursor l_pdt_deal_csr (p_pdt_id in number) is
124: SELECT ppv.quality_val deal_type
125: FROM okl_prod_qlty_val_uv ppv

Line 125: FROM okl_prod_qlty_val_uv ppv

121: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
122: --cursor to get deal type corresponding to a product
123: Cursor l_pdt_deal_csr (p_pdt_id in number) is
124: SELECT ppv.quality_val deal_type
125: FROM okl_prod_qlty_val_uv ppv
126: WHERE ppv.quality_name IN ('LEASE','INVESTOR')
127: AND ppv.pdt_id = p_pdt_id;
128:
129: l_pdt_deal_rec l_pdt_deal_csr%ROWTYPE;

Line 596: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v

592: and khr.id = p_chr_id;
593:
594: l_deal_type_rec l_deal_type_csr%ROWTYPE;
595:
596: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
597: --cursor to get deal type corresponding to a product
598: Cursor l_pdt_deal_csr (p_pdt_id in number) is
599: SELECT ppv.quality_val deal_type
600: FROM okl_prod_qlty_val_uv ppv

Line 600: FROM okl_prod_qlty_val_uv ppv

596: --dkagrawa changed cursor to use view OKL_PROD_QLTY_VAL_UV than okl_product_parameters_v
597: --cursor to get deal type corresponding to a product
598: Cursor l_pdt_deal_csr (p_pdt_id in number) is
599: SELECT ppv.quality_val deal_type
600: FROM okl_prod_qlty_val_uv ppv
601: WHERE ppv.quality_name IN ('LEASE','INVESTOR')
602: AND ppv.pdt_id = p_pdt_id;
603:
604: l_pdt_deal_rec l_pdt_deal_csr%ROWTYPE;