APPS.OKL_LEASE_APP_PVT dependencies on OKL_LEASEAPP_TEMPL_VERSIONS_V

Line 2266: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV

2262: ,LSQ.ID LSQ_ID
2263: FROM OKL_LEASE_APPLICATIONS_B LAB
2264: ,OKL_LEASEAPP_TEMPLATES LAT
2265: ,OKL_LEASE_QUOTES_B LSQ
2266: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
2267: WHERE LATV.ID = LAB.LEASEAPP_TEMPLATE_ID
2268: AND LAT.ID = LATV.LEASEAPP_TEMPLATE_ID
2269: AND LSQ.PARENT_OBJECT_CODE = 'LEASEAPP'
2270: AND LSQ.PARENT_OBJECT_ID = LAB.ID

Line 2931: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV

2927: CURSOR chk_hdr_dtls_csr(cp_lap_id NUMBER)
2928: IS
2929: SELECT LATV.CHECKLIST_ID
2930: FROM OKL_LEASE_APPLICATIONS_B LAP
2931: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
2932: WHERE LAP.LEASEAPP_TEMPLATE_ID = LATV.ID
2933: AND LAP.ID = cp_lap_id;
2934: chk_hdr_dtls_rec chk_hdr_dtls_csr%ROWTYPE;
2935:

Line 3680: FROM OKL_LEASEAPP_TEMPL_VERSIONS_V LATV

3676: IS
3677: SELECT LATV.CHECKLIST_ID
3678: ,LAT.CREDIT_REVIEW_PURPOSE
3679: ,LAT.CUST_CREDIT_CLASSIFICATION
3680: FROM OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
3681: ,OKL_LEASEAPP_TEMPLATES LAT
3682: WHERE LATV.LEASEAPP_TEMPLATE_ID = LAT.ID
3683: AND LATV.ID = cp_latv_id;
3684: chk_hdr_dtls_rec chk_hdr_dtls_csr%ROWTYPE;

Line 4226: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV

4222: --Cursor for Lease Application Template details
4223: CURSOR lat_dtls_csr(cp_tmpl_id NUMBER, cp_valid_from DATE) IS
4224: SELECT LAT.NAME LEASEAPP_TMPL_NAME
4225: FROM OKL_LEASEAPP_TEMPLATES LAT
4226: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
4227: WHERE (LATV.VERSION_STATUS <> 'ACTIVE' OR
4228: LATV.VALID_FROM > cp_valid_from OR
4229: NVL(LATV.VALID_TO, TO_DATE('31-12-9999', 'dd-mm-yyyy')) < cp_valid_from)
4230: AND LATV.ID = cp_tmpl_id

Line 4321: , OKL_LEASEAPP_TEMPL_VERSIONS_V LATV

4317: CURSOR checklist_val_csr(p_latv_id NUMBER, p_valid_from DATE)
4318: IS
4319: SELECT CHECKLIST_NUMBER TEMPLATE_NUMBER
4320: FROM OKL_CHECKLISTS CHK
4321: , OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
4322: , OKL_LEASEAPP_TEMPLATES LAT
4323: WHERE LATV.CHECKLIST_ID = CHK.ID
4324: AND LATV.LEASEAPP_TEMPLATE_ID = LAT.ID
4325: AND ( (p_valid_from NOT BETWEEN NVL(CHK.START_DATE, p_valid_from)

Line 4337: , OKL_LEASEAPP_TEMPL_VERSIONS_V LATV

4333: CURSOR contract_tmpl_val_csr(p_latv_id NUMBER, p_valid_from DATE)
4334: IS
4335: SELECT CHR.CONTRACT_NUMBER TEMPLATE_NUMBER
4336: FROM OKC_K_HEADERS_B CHR
4337: , OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
4338: , OKL_LEASEAPP_TEMPLATES LAT
4339: , OKL_K_HEADERS KHR
4340: , OKC_STATUSES_V STS
4341: WHERE LATV.CONTRACT_TEMPLATE_ID = CHR.ID

Line 5496: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV

5492: CURSOR chk_hdr_dtls_csr(cp_lap_id NUMBER)
5493: IS
5494: SELECT LATV.CHECKLIST_ID
5495: FROM OKL_LEASE_APPLICATIONS_B LAP
5496: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
5497: WHERE LAP.LEASEAPP_TEMPLATE_ID = LATV.ID
5498: AND LAP.ID = cp_lap_id;
5499: chk_hdr_dtls_rec chk_hdr_dtls_csr%ROWTYPE;
5500:

Line 7370: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV

7366: --Cursor to obtain Lease Application Template Details
7367: CURSOR lat_dtls_csr(cp_lat_id NUMBER) IS
7368: SELECT LAT.NAME LAT_NUMBER
7369: FROM OKL_LEASEAPP_TEMPLATES LAT
7370: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
7371: WHERE LATV.LEASEAPP_TEMPLATE_ID = LAT.ID
7372: AND LATV.ID = cp_lat_id;
7373: lat_dtls_rec lat_dtls_csr%ROWTYPE;
7374:

Line 8468: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV

8464: IS
8465: --changing the query for bug 5167776
8466: SELECT LATV.CHECKLIST_ID
8467: FROM OKL_LEASE_APPLICATIONS_B LAP
8468: ,OKL_LEASEAPP_TEMPL_VERSIONS_V LATV
8469: WHERE LAP.LEASEAPP_TEMPLATE_ID = LATV.ID
8470: AND LAP.ID = cp_lap_id;
8471: chk_hdr_dtls_rec chk_hdr_dtls_csr%ROWTYPE;
8472: