APPS.OKL_AM_BTCH_EXP_LEASE_LOAN_PVT dependencies on OKC_K_HEADERS_B

Line 1121: FROM okc_k_headers_b CHR

1117: CURSOR l_get_k_dtls_csr (p_chr_id IN NUMBER) IS
1118: SELECT CHR.start_date,
1119: CHR.end_date,
1120: CHR.sts_code
1121: FROM okc_k_headers_b CHR
1122: WHERE CHR.ID = p_chr_id;
1123:
1124: -- Get contract termination transaction which is not PROCESSED or CANCELED ie ERROR
1125: CURSOR l_get_k_trn_csr (p_chr_id IN NUMBER) IS

Line 3691: FROM okc_k_headers_b khr

3687: trx_id
3688: FROM (SELECT khr.contract_number contract_number,
3689: khr.ID khr_id,
3690: NULL trx_id
3691: FROM okc_k_headers_b khr
3692: WHERE TRUNC (khr.end_date) < TRUNC (SYSDATE)
3693: AND NVL (khr.sts_code, '?') IN ('BOOKED')
3694: AND khr.scs_code IN ('LEASE', 'LOAN')
3695: -- rmunjulu --start -- added the following or else same record picked twice

Line 3733: FROM okc_k_headers_b k, okl_trx_contracts t

3729: UNION
3730: SELECT k.contract_number,
3731: k.ID khr_id,
3732: t.ID trx_id
3733: FROM okc_k_headers_b k, okl_trx_contracts t
3734: WHERE NVL (t.tmt_recycle_yn, '?') = 'Y'
3735: AND NVL (t.tmt_status_code, '?') NOT IN
3736: ('PROCESSED', 'CANCELED')
3737: --akrangan changed for sla tmt_status_Code cr