APPS.OKL_SETUPPRODUCTS_PVT dependencies on OKL_PDT_QUALITYS_V

Line 392: FROM okl_pdt_qualitys_v pqy,

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:

Line 561: okl_pdt_qualitys_v pqy,

557: -- ALLOW REPORTING PRODUCT FOR LOCAL SECURITIZATION PRODUCT
558: SELECT COUNT(pqy.id)
559: INTO l_invalid_product_cnt
560: FROM
561: okl_pdt_qualitys_v pqy,
562: okl_pdt_pqys_v pdq
563: where pqy.id = pdq.pqy_id
564: AND pdq.ptl_id = p_pdtv_rec.ptl_id
565: AND pqy.name = 'INVESTOR';

Line 577: from okl_pdt_qualitys_v pqy,

573: where id = p_upd_pdtv_rec.reporting_pdt_id;
574:
575: select count(pqy.id)
576: into l_invalid_product_cnt
577: from okl_pdt_qualitys_v pqy,
578: okl_pdt_pqys_v pdq
579: where pqy.id = pdq.pqy_id
580: and pdq.ptl_id = l_rep_ptl_id
581: and pqy.name = 'INVESTOR';

Line 598: okl_pdt_qualitys_v pqy,

594: -- INVESTOR AGREEMENT CLASSIFICATION is defined for a product.
595: SELECT COUNT(pqy.id)
596: INTO l_quality_miss_cnt
597: FROM
598: okl_pdt_qualitys_v pqy,
599: okl_pdt_pqys_v pdq
600: WHERE pqy.id = pdq.pqy_id
601: AND pdq.ptl_id = p_pdtv_rec.ptl_id
602: AND pqy.name IN ('LEASE','INVESTOR','TAXOWNER');

Line 1946: OKL_PQY_VALUES_V QVE,OKL_PDT_QUALITYS_V PQY

1942: AND b.id = p_aes_id
1943: INTERSECT
1944: SELECT DISTINCT PQY.NAME
1945: FROM okl_PDT_PQYS_V PDQ,
1946: OKL_PQY_VALUES_V QVE,OKL_PDT_QUALITYS_V PQY
1947: WHERE PQY.ID = QVE.PQY_ID
1948: AND PQY.ID= PDQ.PQY_ID
1949: AND PDQ.PTL_ID = p_PTL_ID
1950: AND pqy.name IN('LEASE','INVESTOR');

Line 3971: OKL_PQY_VALUES_V QVE,OKL_PDT_QUALITYS_V PQY

3967: AND b.id = p_aes_id
3968: INTERSECT
3969: SELECT DISTINCT PQY.NAME
3970: FROM okl_PDT_PQYS_V PDQ,
3971: OKL_PQY_VALUES_V QVE,OKL_PDT_QUALITYS_V PQY
3972: WHERE PQY.ID = QVE.PQY_ID
3973: AND PQY.ID= PDQ.PQY_ID
3974: AND PDQ.PTL_ID = p_PTL_ID
3975: AND pqy.name IN('LEASE','INVESTOR');

Line 4169: OKL_PQY_VALUES_V QVE,OKL_PDT_QUALITYS_V PQY

4165: AND b.id = p_aes_id
4166: INTERSECT
4167: SELECT DISTINCT PQY.NAME
4168: FROM okl_PDT_PQYS_V PDQ,
4169: OKL_PQY_VALUES_V QVE,OKL_PDT_QUALITYS_V PQY
4170: WHERE PQY.ID = QVE.PQY_ID
4171: AND PQY.ID= PDQ.PQY_ID
4172: AND PDQ.PTL_ID = p_PTL_ID
4173: AND pqy.name IN('LEASE','INVESTOR');