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 623: FROM okl_pqy_values_v qve,

619: p_db_pdtv_rec.ptl_id <> p_pdtv_rec.ptl_id THEN
620: SELECT COUNT(pqv.id)
621:
622: INTO l_pdt_ptl_changed
623: FROM okl_pqy_values_v qve,
624: okl_pdt_qualitys pqy,
625: okl_pdt_pqys_v pdq,
626: okl_pdt_pqy_vals pqv
627: WHERE qve.pqy_id = pqy.id

Line 657: FROM okl_pqy_values_v qve

653: IF csr_rec.name = 'LEASE' THEN
654:
655: SELECT COUNT(qve.id)
656: INTO l_lease_values_miss_cnt
657: FROM okl_pqy_values_v qve
658: WHERE qve.pqy_id = csr_rec.id
659: AND qve.value IN ('LEASEDF','LEASEOP','LEASEST','LOAN','LOAN-REVOLVING');
660:
661: IF l_lease_values_miss_cnt <> 5 THEN

Line 677: FROM okl_pqy_values_v qve

673:
674: IF csr_rec.name = 'TAXOWNER' THEN
675: SELECT COUNT(qve.id)
676: INTO l_taxown_values_miss_cnt
677: FROM okl_pqy_values_v qve
678: WHERE qve.pqy_id = csr_rec.id
679: AND qve.value IN ('LESSEE','LESSOR');
680:
681: IF l_taxown_values_miss_cnt <> 2 THEN

Line 697: okl_pqy_values_v qve

693:
694: SELECT COUNT(qve.id)
695: INTO l_sec_values_miss_cnt
696: FROM
697: okl_pqy_values_v qve
698: WHERE qve.pqy_id = csr_rec.id
699: AND qve.value IN ('SECURITIZATION','SYNDICATION');
700:
701: IF l_sec_values_miss_cnt <> 2 THEN

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