[Home] [Help]
388:
389: CURSOR choose_qlty_csr(cp_ptl_id okl_pdt_templates_v.id%TYPE) IS
390: SELECT DISTINCT pqy.id id,
391: pqy.name name
392: FROM okl_pdt_qualitys_v pqy,
393: okl_pdt_pqys_v pdq
394: WHERE pqy.id = pdq.pqy_id
395: AND pdq.ptl_id = cp_ptl_id
396:
555: -- CHECK TO DISALLOW REPORTING PRODUCT FOR LOCAL SECURITIZATION PRODUCT
556: SELECT COUNT(pqy.id)
557: INTO l_invalid_product_cnt
558: FROM
559: okl_pdt_qualitys_v pqy,
560: okl_pdt_pqys_v pdq
561: where pqy.id = pdq.pqy_id
562: AND pdq.ptl_id = p_pdtv_rec.ptl_id
563: AND pqy.name = 'INVESTOR';
577: -- INVESTOR AGREEMENT CLASSIFICATION is defined for a product.
578: SELECT COUNT(pqy.id)
579: INTO l_quality_miss_cnt
580: FROM
581: okl_pdt_qualitys_v pqy,
582: okl_pdt_pqys_v pdq
583: WHERE pqy.id = pdq.pqy_id
584: AND pdq.ptl_id = p_pdtv_rec.ptl_id
585: AND pqy.name IN ('LEASE','INVESTOR','TAXOWNER');
603: SELECT COUNT(pqv.id)
604:
605: INTO l_pdt_ptl_changed
606: FROM okl_pqy_values_v qve,
607: okl_pdt_qualitys pqy,
608: okl_pdt_pqys_v pdq,
609: okl_pdt_pqy_vals pqv
610: WHERE qve.pqy_id = pqy.id
611: AND pqv.qve_id = qve.id
1925: AND b.id = p_aes_id
1926: INTERSECT
1927: SELECT DISTINCT PQY.NAME
1928: FROM okl_PDT_PQYS_V PDQ,
1929: OKL_PQY_VALUES_V QVE,OKL_PDT_QUALITYS_V PQY
1930: WHERE PQY.ID = QVE.PQY_ID
1931: AND PQY.ID= PDQ.PQY_ID
1932: AND PDQ.PTL_ID = p_PTL_ID
1933: AND pqy.name IN('LEASE','INVESTOR');
3938: AND b.id = p_aes_id
3939: INTERSECT
3940: SELECT DISTINCT PQY.NAME
3941: FROM okl_PDT_PQYS_V PDQ,
3942: OKL_PQY_VALUES_V QVE,OKL_PDT_QUALITYS_V PQY
3943: WHERE PQY.ID = QVE.PQY_ID
3944: AND PQY.ID= PDQ.PQY_ID
3945: AND PDQ.PTL_ID = p_PTL_ID
3946: AND pqy.name IN('LEASE','INVESTOR');
4136: AND b.id = p_aes_id
4137: INTERSECT
4138: SELECT DISTINCT PQY.NAME
4139: FROM okl_PDT_PQYS_V PDQ,
4140: OKL_PQY_VALUES_V QVE,OKL_PDT_QUALITYS_V PQY
4141: WHERE PQY.ID = QVE.PQY_ID
4142: AND PQY.ID= PDQ.PQY_ID
4143: AND PDQ.PTL_ID = p_PTL_ID
4144: AND pqy.name IN('LEASE','INVESTOR');