APPS.OKL_MAINTAIN_FEE_PVT dependencies on OKC_STATUSES_V

Line 4111: FROM okc_statuses_v okcsts

4107: AND trunc(qte.date_effective_from) <= cle.start_date
4108: AND nvl(trunc(qte.date_effective_to), cle.start_date) >= cle.start_date
4109: AND NOT EXISTS (
4110: SELECT 'Y'
4111: FROM okc_statuses_v okcsts
4112: WHERE okcsts.code = cle.sts_code
4113: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED', 'ABANDONED'))
4114: AND NOT EXISTS (
4115: SELECT 'Y'

Line 4139: FROM okc_statuses_v okcsts

4135: AND kle1.fee_type = 'ROLLOVER'
4136: AND kle1.qte_id = qteID
4137: AND NOT EXISTS (
4138: SELECT 'Y'
4139: FROM okc_statuses_v okcsts
4140: WHERE okcsts.code = cleb.sts_code
4141: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED', 'ABANDONED'))
4142: /* Added to exclude this check for Re-lease contracts. */
4143: AND NOT EXISTS (