APPS.OKL_AM_BTCH_EXP_LEASE_LOAN_PVT dependencies on OKC_K_LINES_B

Line 3757: FROM OKC_K_LINES_B KLE,

3753: -- GET DATA VOLUME BASED ON WHICH WILL DECIDE WHICH PARALLEL PROCESS TO USE.
3754: --Bug # 6174484 fixed for SQL Performance ssdehpa start
3755: CURSOR chk_data_volume_csr (p_seq_next VARCHAR2) IS
3756: /* SELECT opp.object_value contract_number , count(KLE.id) line_count
3757: FROM OKC_K_LINES_B KLE,
3758: okl_parallel_processes opp
3759: WHERE opp.khr_id = KLE.dnz_chr_id
3760: AND KLE.sts_code = ('BOOKED')
3761: AND opp.khr_id NOT IN(

Line 3785: OKC_K_LINES_B KLE

3781: UNION
3782: SELECT opp.object_value contract_number, count(KLE.id) line_count
3783: FROM okl_parallel_processes opp,
3784: OKL_TRX_CONTRACTS T,
3785: OKC_K_LINES_B KLE
3786: WHERE NVL(T.tmt_recycle_yn,'?') = 'Y'
3787: AND opp.khr_id = KLE.dnz_chr_id
3788: AND KLE.sts_code = 'BOOKED'
3789: AND NVL(T.tmt_status_code,'?') NOT IN('PROCESSED', 'CANCELED')--akrangan changed for sla tmt_status_Code cr

Line 3797: FROM okc_k_lines_b kle, okl_parallel_processes opp

3793: AND opp.assigned_process = p_seq_next
3794: GROUP BY opp.object_value; */
3795: SELECT opp.object_value contract_number,
3796: COUNT (kle.ID) line_count
3797: FROM okc_k_lines_b kle, okl_parallel_processes opp
3798: WHERE opp.khr_id = kle.dnz_chr_id
3799: AND kle.sts_code = ('BOOKED')
3800: AND opp.khr_id NOT IN (
3801: SELECT NVL (tcn.khr_id, -9999) khr_id

Line 3835: okc_k_lines_b kle

3831: SELECT opp.object_value contract_number,
3832: COUNT (kle.ID) line_count
3833: FROM okl_parallel_processes opp,
3834: okl_trx_contracts t,
3835: okc_k_lines_b kle
3836: WHERE NVL (t.tmt_recycle_yn, '?') = 'Y'
3837: AND opp.khr_id = kle.dnz_chr_id
3838: AND kle.sts_code = 'BOOKED'
3839: AND NVL (t.tmt_status_code, '?') NOT IN