APPS.OKL_LEASE_APP_PVT dependencies on OKC_STATUSES_V

Line 4243: , OKC_STATUSES_V PSTS

4239: , PSTS.STE_CODE
4240: , CHR.START_DATE START_DATE
4241: , CHR.END_DATE END_DATE
4242: FROM OKC_K_HEADERS_B CHR
4243: , OKC_STATUSES_V PSTS
4244: WHERE CHR.SCS_CODE = 'PROGRAM'
4245: AND CHR.STS_CODE = PSTS.CODE
4246: AND CHR.ID = cp_pgm_agr_id;
4247: pgm_agr_dtls_rec pgm_agr_dtls_csr%ROWTYPE;

Line 4340: , OKC_STATUSES_V STS

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
4342: AND LATV.LEASEAPP_TEMPLATE_ID = LAT.ID
4343: AND CHR.ID = KHR.ID
4344: AND CHR.STS_CODE = STS.CODE

Line 9785: , OKC_STATUSES_V CSTS

9781: CURSOR contract_dtls_csr(p_lap_id NUMBER)
9782: IS
9783: SELECT CHR.CONTRACT_NUMBER CONTRACT_NUMBER
9784: FROM OKC_K_HEADERS_B CHR
9785: , OKC_STATUSES_V CSTS
9786: WHERE CHR.ORIG_SYSTEM_SOURCE_CODE = 'OKL_LEASE_APP'
9787: AND CHR.STS_CODE = CSTS.CODE
9788: AND CSTS.STE_CODE <> 'CANCELLED'
9789: AND CHR.ORIG_SYSTEM_ID1 = p_lap_id;

Line 11845: , OKC_STATUSES_V CSTS

11841: FROM OKL_LEASE_APPLICATIONS_B LAB
11842: , OKL_LEASE_APPLICATIONS_B CLAB
11843: , OKL_LEASE_OPPORTUNITIES_B LOP
11844: , OKC_K_HEADERS_B CHR
11845: , OKC_STATUSES_V CSTS
11846: WHERE LAB.LEASE_OPPORTUNITY_ID = CLAB.LEASE_OPPORTUNITY_ID
11847: AND LOP.ID = LAB.LEASE_OPPORTUNITY_ID
11848: AND LAB.ID <> CLAB.ID
11849: AND LAB.APPLICATION_STATUS = 'CONV-K'

Line 11868: , OKC_STATUSES_V CSTS

11864: FROM OKL_LEASE_QUOTES_B LSQ
11865: , OKL_LEASE_APPLICATIONS_B CLAB
11866: , OKL_LEASE_OPPORTUNITIES_B LOP
11867: , OKC_K_HEADERS_B CHR
11868: , OKC_STATUSES_V CSTS
11869: WHERE LOP.ID = CLAB.LEASE_OPPORTUNITY_ID
11870: AND CHR.ORIG_SYSTEM_ID1 = LOP.ID
11871: AND CHR.ORIG_SYSTEM_SOURCE_CODE = 'OKL_QUOTE'
11872: AND CSTS.CODE = CHR.STS_CODE