APPS.OKL_PAYMENT_SPLIT_PVT dependencies on OKC_STATUSES_V

Line 366: FROM okc_statuses_v okcsts

362: )
363: -- added to handle abandon line
364: AND NOT EXISTS (
365: SELECT 'Y'
366: FROM okc_statuses_v okcsts
367: WHERE okcsts.code = line.sts_code
368: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED'));
369:
370: -- Total Capital amount from FEE Top Line

Line 386: FROM okc_statuses_v okcsts

382: AND item.object1_id1 = stream.id1
383: -- added to handle abandon line
384: AND NOT EXISTS (
385: SELECT 'Y'
386: FROM okc_statuses_v okcsts
387: WHERE okcsts.code = line.sts_code
388: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED'));
389:
390: l_fin_amount NUMBER;