APPS.OKL_MAINTAIN_FEE_PVT dependencies on OKC_STATUSES_V

Line 4098: FROM okc_statuses_v okcsts

4094: AND trunc(qte.date_effective_from) <= cle.start_date
4095: AND nvl(trunc(qte.date_effective_to), cle.start_date) >= cle.start_date
4096: AND NOT EXISTS (
4097: SELECT 'Y'
4098: FROM okc_statuses_v okcsts
4099: WHERE okcsts.code = cle.sts_code
4100: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED', 'ABANDONED'))
4101: AND NOT EXISTS (
4102: SELECT 'Y'

Line 4126: FROM okc_statuses_v okcsts

4122: AND kle1.fee_type = 'ROLLOVER'
4123: AND kle1.qte_id = qteID
4124: AND NOT EXISTS (
4125: SELECT 'Y'
4126: FROM okc_statuses_v okcsts
4127: WHERE okcsts.code = cleb.sts_code
4128: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED', 'ABANDONED'))
4129: /* Added to exclude this check for Re-lease contracts. */
4130: AND NOT EXISTS (