APPS.OKL_LEASE_APP_PVT dependencies on OKL_LEASEAPP_TEMPL_VERSIONS_V

Line 2224: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV

2220: ,LSQ.ID LSQ_ID
2221: FROM OKL_LEASE_APPLICATIONS_B LAB
2222: ,OKL_LEASEAPP_TEMPLATES LAT
2223: ,OKL_LEASE_QUOTES_B LSQ
2224: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
2225: WHERE LATV.ID = LAB.LEASEAPP_TEMPLATE_ID
2226: AND LAT.ID = LATV.LEASEAPP_TEMPLATE_ID
2227: AND LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'
2228: AND LSQ.PARENT_OBJECT_ID = LAB.ID

Line 2889: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV

2885: CURSOR chk_hdr_dtls_csr(cp_lap_id NUMBER)
2886: IS
2887: SELECT LATV.CHECKLIST_ID
2888: FROM OKL_LEASE_APPLICATIONS_B LAP
2889: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
2890: WHERE LAP.LEASEAPP_TEMPLATE_ID = LATV.ID
2891: AND LAP.ID = cp_lap_id;
2892: chk_hdr_dtls_rec chk_hdr_dtls_csr%ROWTYPE;
2893:

Line 3592: FROM OKL_LEASEAPP_TEMPL_VERSIONS_V LATV

3588: IS
3589: SELECT LATV.CHECKLIST_ID
3590: ,LAT.CREDIT_REVIEW_PURPOSE
3591: ,LAT.CUST_CREDIT_CLASSIFICATION
3592: FROM OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
3593: ,OKL_LEASEAPP_TEMPLATES LAT
3594: WHERE LATV.LEASEAPP_TEMPLATE_ID = LAT.ID
3595: AND LATV.ID = cp_latv_id;
3596: chk_hdr_dtls_rec chk_hdr_dtls_csr%ROWTYPE;

Line 4138: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV

4134: --Cursor for Lease Application Template details
4135: CURSOR lat_dtls_csr(cp_tmpl_id NUMBER, cp_valid_from DATE) IS
4136: SELECT LAT.NAME LEASEAPP_TMPL_NAME
4137: FROM OKL_LEASEAPP_TEMPLATES LAT
4138: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
4139: WHERE (LATV.VERSION_STATUS <> 'ACTIVE' OR
4140: LATV.VALID_FROM > cp_valid_from OR
4141: NVL(LATV.VALID_TO, TO_DATE('31-12-9999', 'dd-mm-yyyy')) < cp_valid_from)
4142: AND LATV.ID = cp_tmpl_id

Line 4233: , OKL_LEASEAPP_TEMPL_VERSIONS_V LATV

4229: CURSOR checklist_val_csr(p_latv_id NUMBER, p_valid_from DATE)
4230: IS
4231: SELECT CHECKLIST_NUMBER TEMPLATE_NUMBER
4232: FROM OKL_CHECKLISTS CHK
4233: , OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
4234: , OKL_LEASEAPP_TEMPLATES LAT
4235: WHERE LATV.CHECKLIST_ID = CHK.ID
4236: AND LATV.LEASEAPP_TEMPLATE_ID = LAT.ID
4237: AND ( (p_valid_from NOT BETWEEN NVL(CHK.START_DATE, p_valid_from)

Line 4249: , OKL_LEASEAPP_TEMPL_VERSIONS_V LATV

4245: CURSOR contract_tmpl_val_csr(p_latv_id NUMBER, p_valid_from DATE)
4246: IS
4247: SELECT CHR.CONTRACT_NUMBER TEMPLATE_NUMBER
4248: FROM OKC_K_HEADERS_B CHR
4249: , OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
4250: , OKL_LEASEAPP_TEMPLATES LAT
4251: , OKL_K_HEADERS KHR
4252: , OKC_STATUSES_V STS
4253: WHERE LATV.CONTRACT_TEMPLATE_ID = CHR.ID

Line 5408: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV

5404: CURSOR chk_hdr_dtls_csr(cp_lap_id NUMBER)
5405: IS
5406: SELECT LATV.CHECKLIST_ID
5407: FROM OKL_LEASE_APPLICATIONS_B LAP
5408: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
5409: WHERE LAP.LEASEAPP_TEMPLATE_ID = LATV.ID
5410: AND LAP.ID = cp_lap_id;
5411: chk_hdr_dtls_rec chk_hdr_dtls_csr%ROWTYPE;
5412:

Line 7239: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV

7235: --Cursor to obtain Lease Application Template Details
7236: CURSOR lat_dtls_csr(cp_lat_id NUMBER) IS
7237: SELECT LAT.NAME LAT_NUMBER
7238: FROM OKL_LEASEAPP_TEMPLATES LAT
7239: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
7240: WHERE LATV.LEASEAPP_TEMPLATE_ID = LAT.ID
7241: AND LATV.ID = cp_lat_id;
7242: lat_dtls_rec lat_dtls_csr%ROWTYPE;
7243:

Line 8337: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV

8333: IS
8334: --changing the query for bug 5167776
8335: SELECT LATV.CHECKLIST_ID
8336: FROM OKL_LEASE_APPLICATIONS_B LAP
8337: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
8338: WHERE LAP.LEASEAPP_TEMPLATE_ID = LATV.ID
8339: AND LAP.ID = cp_lap_id;
8340: chk_hdr_dtls_rec chk_hdr_dtls_csr%ROWTYPE;
8341: