APPS.OKL_LEASE_APP_PVT dependencies on OKL_LEASEAPP_TEMPLATES

Line 2222: ,OKL_LEASEAPP_TEMPLATES LAT

2218: ,LAB.ORG_ID ORG_ID
2219: ,LAB.CREDIT_LINE_ID CREDIT_LINE_ID
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

Line 3593: ,OKL_LEASEAPP_TEMPLATES LAT

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;
3597:

Line 4137: FROM OKL_LEASEAPP_TEMPLATES LAT

4133:
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)

Line 4180: , OKL_LEASEAPP_TEMPLATES LAT

4176: CURSOR lat_pgm_exist_csr(cp_pgm_agr_id NUMBER) IS
4177: SELECT 'X'
4178: FROM OKC_K_HEADERS_B PGM
4179: , OKL_VP_ASSOCIATIONS_V VPA
4180: , OKL_LEASEAPP_TEMPLATES LAT
4181: , OKL_LEASEAPP_TEMPL_VERSIONS_B LATV
4182: WHERE VPA.CHR_ID = PGM.ID
4183: AND VPA.CRS_ID IS NULL
4184: AND VPA.ASSOC_OBJECT_TYPE_CODE = 'LA_TEMPLATE'

Line 4196: , OKL_LEASEAPP_TEMPLATES LAT

4192: CURSOR lat_pgm_val_csr(cp_pgm_agr_id NUMBER, cp_latv_id NUMBER) IS
4193: SELECT 'X'
4194: FROM OKC_K_HEADERS_B PGM
4195: , OKL_VP_ASSOCIATIONS_V VPA
4196: , OKL_LEASEAPP_TEMPLATES LAT
4197: , OKL_LEASEAPP_TEMPL_VERSIONS_B LATV
4198: WHERE VPA.CHR_ID = PGM.ID
4199: AND VPA.CRS_ID IS NULL
4200: AND VPA.ASSOC_OBJECT_TYPE_CODE = 'LA_TEMPLATE'

Line 4234: , OKL_LEASEAPP_TEMPLATES LAT

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)
4238: AND NVL(CHK.END_DATE, p_valid_from))

Line 4250: , OKL_LEASEAPP_TEMPLATES LAT

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
4254: AND LATV.LEASEAPP_TEMPLATE_ID = LAT.ID

Line 7238: FROM OKL_LEASEAPP_TEMPLATES LAT

7234:
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;