APPS.OKL_PAYMENT_APPLICATION_PVT dependencies on OKC_STATUSES_V

Line 102: FROM okc_statuses_v okcsts,

98: AND cle.id = rg.cle_id
99: -- added to handle abandon line
100: AND NOT EXISTS (
101: SELECT 'Y'
102: FROM okc_statuses_v okcsts,
103: okc_k_lines_b line
104: WHERE line.id = rg.cle_id
105: AND line.sts_code = okcsts.code
106: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED'));

Line 190: FROM okc_statuses_v okcsts,

186: AND lsb.lty_code = 'LINK_FEE_ASSET'
187: -- added to handle abandon line
188: AND NOT EXISTS (
189: SELECT 'Y'
190: FROM okc_statuses_v okcsts,
191: okc_k_lines_b line
192: WHERE line.id = rg.cle_id
193: AND line.sts_code = okcsts.code
194: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED'));

Line 1480: FROM okc_statuses_v okcsts

1476: )
1477: -- added to handle abandon line
1478: AND NOT EXISTS (
1479: SELECT 'Y'
1480: FROM okc_statuses_v okcsts
1481: WHERE okcsts.code = line.sts_code
1482: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED'));
1483:
1484:

Line 2237: FROM okc_statuses_v okcsts

2233: AND rgp.cle_id = okl.id
2234: -- added to handle abandon line
2235: AND NOT EXISTS (
2236: SELECT 'Y'
2237: FROM okc_statuses_v okcsts
2238: WHERE okcsts.code = okl.sts_code
2239: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED'));
2240:
2241: line_rec line_csr%ROWTYPE;

Line 2259: okc_statuses_v okcsts,

2255: CURSOR line_cap_csr (p_chr_id NUMBER) IS
2256: SELECT SUM(NVL(line.oec,0)) tot_cap
2257: FROM okl_k_lines_full_v line,
2258: okc_line_styles_v style,
2259: okc_statuses_v okcsts,
2260: okc_rules_b rule,
2261: okc_rule_groups_b rgp
2262: WHERE line.dnz_chr_id = p_chr_id
2263: AND line.lse_id = style.id

Line 2565: FROM okc_statuses_v okcsts

2561: AND cleb.CLE_ID = p_kle_id
2562: -- AND cleb.sts_code NOT IN ('HOLD','EXPIRED','TERMINATED','CANCELLED');
2563: AND NOT EXISTS (
2564: SELECT 'Y'
2565: FROM okc_statuses_v okcsts
2566: WHERE okcsts.code = cleb.sts_code
2567: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED'));
2568:
2569: -- Total Fee amount for the rollover fee top line.

Line 2900: FROM okc_statuses_v okcsts

2896: AND cleb.CLE_ID = p_kle_id
2897: -- AND cleb.sts_code NOT IN ('HOLD','EXPIRED','TERMINATED','CANCELLED');
2898: AND NOT EXISTS (
2899: SELECT 'Y'
2900: FROM okc_statuses_v okcsts
2901: WHERE okcsts.code = cleb.sts_code
2902: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED'));
2903:
2904: -- Total Fee amount for the rollover fee top line.