APPS.OKL_LEASE_APP_PVT dependencies on OKC_K_HEADERS_B

Line 4242: FROM OKC_K_HEADERS_B CHR

4238: , CHR.STS_CODE
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;

Line 4266: FROM OKC_K_HEADERS_B PGM

4262: --Cursor for Lease Application Template and Vendor Program Association validation
4263: --Bug abhsaxen 5158188 for validation of VPA is having any LAT
4264: CURSOR lat_pgm_exist_csr(cp_pgm_agr_id NUMBER) IS
4265: SELECT 'X'
4266: FROM OKC_K_HEADERS_B PGM
4267: , OKL_VP_ASSOCIATIONS_V VPA
4268: , OKL_LEASEAPP_TEMPLATES LAT
4269: , OKL_LEASEAPP_TEMPL_VERSIONS_B LATV
4270: WHERE VPA.CHR_ID = PGM.ID

Line 4282: FROM OKC_K_HEADERS_B PGM

4278: lat_pgm_exist_rec lat_pgm_exist_csr%ROWTYPE;
4279: --Bug 4873205 PAGARG modified the query to validate validation
4280: CURSOR lat_pgm_val_csr(cp_pgm_agr_id NUMBER, cp_latv_id NUMBER) IS
4281: SELECT 'X'
4282: FROM OKC_K_HEADERS_B PGM
4283: , OKL_VP_ASSOCIATIONS_V VPA
4284: , OKL_LEASEAPP_TEMPLATES LAT
4285: , OKL_LEASEAPP_TEMPL_VERSIONS_B LATV
4286: WHERE VPA.CHR_ID = PGM.ID

Line 4336: FROM OKC_K_HEADERS_B CHR

4332: --Validate Contract Template Cursor
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

Line 7173: FROM OKC_K_HEADERS_B CHR

7169:
7170: --Cursor to obtain Program Agreement Details
7171: CURSOR pgm_agr_dtls_csr(cp_pgm_agr_id NUMBER) IS
7172: SELECT CONTRACT_NUMBER PROGRAM_AGREEMENT
7173: FROM OKC_K_HEADERS_B CHR
7174: WHERE CHR.ID = cp_pgm_agr_id
7175: AND CHR.SCS_CODE = 'PROGRAM';
7176: pgm_agr_dtls_rec pgm_agr_dtls_csr%ROWTYPE;
7177:

Line 9784: FROM OKC_K_HEADERS_B CHR

9780: --Cursor to Obtain Contract Number created from given lease app
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'

Line 11844: , OKC_K_HEADERS_B CHR

11840: , CHR.CONTRACT_NUMBER CONTRACT_NUMBER
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

Line 11867: , OKC_K_HEADERS_B CHR

11863: , CHR.CONTRACT_NUMBER CONTRACT_NUMBER
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'