APPS.OKL_AM_BTCH_EXP_LEASE_LOAN_PVT dependencies on OKC_K_LINES_B

Line 3840: FROM OKC_K_LINES_B KLE,

3836: -- GET DATA VOLUME BASED ON WHICH WILL DECIDE WHICH PARALLEL PROCESS TO USE.
3837: --Bug # 6174484 fixed for SQL Performance ssdehpa start
3838: CURSOR chk_data_volume_csr (p_seq_next VARCHAR2) IS
3839: /* SELECT opp.object_value contract_number , count(KLE.id) line_count
3840: FROM OKC_K_LINES_B KLE,
3841: okl_parallel_processes opp
3842: WHERE opp.khr_id = KLE.dnz_chr_id
3843: AND KLE.sts_code = ('BOOKED')
3844: AND opp.khr_id NOT IN(

Line 3868: OKC_K_LINES_B KLE

3864: UNION
3865: SELECT opp.object_value contract_number, count(KLE.id) line_count
3866: FROM okl_parallel_processes opp,
3867: OKL_TRX_CONTRACTS T,
3868: OKC_K_LINES_B KLE
3869: WHERE NVL(T.tmt_recycle_yn,'?') = 'Y'
3870: AND opp.khr_id = KLE.dnz_chr_id
3871: AND KLE.sts_code = 'BOOKED'
3872: AND NVL(T.tmt_status_code,'?') NOT IN('PROCESSED', 'CANCELED')--akrangan changed for sla tmt_status_Code cr

Line 3880: FROM okc_k_lines_b kle, okl_parallel_processes opp

3876: AND opp.assigned_process = p_seq_next
3877: GROUP BY opp.object_value; */
3878: SELECT opp.object_value contract_number,
3879: COUNT (kle.ID) line_count
3880: FROM okc_k_lines_b kle, okl_parallel_processes opp
3881: WHERE opp.khr_id = kle.dnz_chr_id
3882: AND kle.sts_code = ('BOOKED')
3883: AND opp.khr_id NOT IN (
3884: SELECT NVL (tcn.khr_id, -9999) khr_id

Line 3918: okc_k_lines_b kle

3914: SELECT opp.object_value contract_number,
3915: COUNT (kle.ID) line_count
3916: FROM okl_parallel_processes opp,
3917: okl_trx_contracts t,
3918: okc_k_lines_b kle
3919: WHERE NVL (t.tmt_recycle_yn, '?') = 'Y'
3920: AND opp.khr_id = kle.dnz_chr_id
3921: AND kle.sts_code = 'BOOKED'
3922: AND NVL (t.tmt_status_code, '?') NOT IN