APPS.OKL_LEASE_APP_PVT dependencies on OKC_STATUSES_V

Line 4155: , OKC_STATUSES_V PSTS

4151: , PSTS.STE_CODE
4152: , CHR.START_DATE START_DATE
4153: , CHR.END_DATE END_DATE
4154: FROM OKC_K_HEADERS_B CHR
4155: , OKC_STATUSES_V PSTS
4156: WHERE CHR.SCS_CODE = 'PROGRAM'
4157: AND CHR.STS_CODE = PSTS.CODE
4158: AND CHR.ID = cp_pgm_agr_id;
4159: pgm_agr_dtls_rec pgm_agr_dtls_csr%ROWTYPE;

Line 4252: , OKC_STATUSES_V STS

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
4255: AND CHR.ID = KHR.ID
4256: AND CHR.STS_CODE = STS.CODE

Line 9654: , OKC_STATUSES_V CSTS

9650: CURSOR contract_dtls_csr(p_lap_id NUMBER)
9651: IS
9652: SELECT CHR.CONTRACT_NUMBER CONTRACT_NUMBER
9653: FROM OKC_K_HEADERS_B CHR
9654: , OKC_STATUSES_V CSTS
9655: WHERE CHR.ORIG_SYSTEM_SOURCE_CODE = 'OKL_LEASE_APP'
9656: AND CHR.STS_CODE = CSTS.CODE
9657: AND CSTS.STE_CODE <> 'CANCELLED'
9658: AND CHR.ORIG_SYSTEM_ID1 = p_lap_id;

Line 11693: , OKC_STATUSES_V CSTS

11689: FROM OKL_LEASE_APPLICATIONS_B LAB
11690: , OKL_LEASE_APPLICATIONS_B CLAB
11691: , OKL_LEASE_OPPORTUNITIES_B LOP
11692: , OKC_K_HEADERS_B CHR
11693: , OKC_STATUSES_V CSTS
11694: WHERE LAB.LEASE_OPPORTUNITY_ID = CLAB.LEASE_OPPORTUNITY_ID
11695: AND LOP.ID = LAB.LEASE_OPPORTUNITY_ID
11696: AND LAB.ID <> CLAB.ID
11697: AND LAB.APPLICATION_STATUS = 'CONV-K'

Line 11716: , OKC_STATUSES_V CSTS

11712: FROM OKL_LEASE_QUOTES_B LSQ
11713: , OKL_LEASE_APPLICATIONS_B CLAB
11714: , OKL_LEASE_OPPORTUNITIES_B LOP
11715: , OKC_K_HEADERS_B CHR
11716: , OKC_STATUSES_V CSTS
11717: WHERE LOP.ID = CLAB.LEASE_OPPORTUNITY_ID
11718: AND CHR.ORIG_SYSTEM_ID1 = LOP.ID
11719: AND CHR.ORIG_SYSTEM_SOURCE_CODE = 'OKL_QUOTE'
11720: AND CSTS.CODE = CHR.STS_CODE