APPS.OKL_SETUPPRODUCTS_PVT dependencies on OKL_PQY_VALUES_V

Line 323: FROM Okl_Pqy_Values_V qve,

319: p_from_date IN Okl_Products_V.FROM_DATE%TYPE,
320: p_to_date IN Okl_Products_V.TO_DATE%TYPE
321: ) IS
322: SELECT '1'
323: FROM Okl_Pqy_Values_V qve,
324: Okl_Pdt_Pqy_Vals_V pqv
325: WHERE pqv.PDT_ID = p_pdt_id
326: AND qve.ID = pqv.QVE_ID
327: AND ((qve.FROM_DATE > p_from_date OR

Line 606: FROM okl_pqy_values_v qve,

602: p_db_pdtv_rec.ptl_id <> p_pdtv_rec.ptl_id THEN
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

Line 640: FROM okl_pqy_values_v qve

636: IF csr_rec.name = 'LEASE' THEN
637:
638: SELECT COUNT(qve.id)
639: INTO l_lease_values_miss_cnt
640: FROM okl_pqy_values_v qve
641: WHERE qve.pqy_id = csr_rec.id
642: AND qve.value IN ('LEASEDF','LEASEOP','LEASEST','LOAN','LOAN-REVOLVING');
643:
644: IF l_lease_values_miss_cnt <> 5 THEN

Line 660: FROM okl_pqy_values_v qve

656:
657: IF csr_rec.name = 'TAXOWNER' THEN
658: SELECT COUNT(qve.id)
659: INTO l_taxown_values_miss_cnt
660: FROM okl_pqy_values_v qve
661: WHERE qve.pqy_id = csr_rec.id
662: AND qve.value IN ('LESSEE','LESSOR');
663:
664: IF l_taxown_values_miss_cnt <> 2 THEN

Line 680: okl_pqy_values_v qve

676:
677: SELECT COUNT(qve.id)
678: INTO l_sec_values_miss_cnt
679: FROM
680: okl_pqy_values_v qve
681: WHERE qve.pqy_id = csr_rec.id
682: AND qve.value IN ('SECURITIZATION','SYNDICATION');
683:
684: IF l_sec_values_miss_cnt <> 2 THEN

Line 1929: OKL_PQY_VALUES_V QVE,OKL_PDT_QUALITYS_V PQY

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');

Line 3942: OKL_PQY_VALUES_V QVE,OKL_PDT_QUALITYS_V PQY

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');

Line 4140: OKL_PQY_VALUES_V QVE,OKL_PDT_QUALITYS_V PQY

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');