APPS.OKL_PAYMENT_APPLICATION_PVT dependencies on OKC_STATUSES_V

Line 98: FROM okc_statuses_v okcsts,

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

Line 186: FROM okc_statuses_v okcsts,

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

Line 1476: FROM okc_statuses_v okcsts

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

Line 1877: FROM okc_statuses_v okcsts

1873: AND rgp.cle_id = okl.id
1874: -- added to handle abandon line
1875: AND NOT EXISTS (
1876: SELECT 'Y'
1877: FROM okc_statuses_v okcsts
1878: WHERE okcsts.code = okl.sts_code
1879: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED'));
1880:
1881: line_rec line_csr%ROWTYPE;

Line 1899: okc_statuses_v okcsts,

1895: CURSOR line_cap_csr (p_chr_id NUMBER) IS
1896: SELECT SUM(NVL(line.oec,0)) tot_cap
1897: FROM okl_k_lines_full_v line,
1898: okc_line_styles_v style,
1899: okc_statuses_v okcsts,
1900: okc_rules_b rule,
1901: okc_rule_groups_b rgp
1902: WHERE line.dnz_chr_id = p_chr_id
1903: AND line.lse_id = style.id

Line 2205: FROM okc_statuses_v okcsts

2201: AND cleb.CLE_ID = p_kle_id
2202: -- AND cleb.sts_code NOT IN ('HOLD','EXPIRED','TERMINATED','CANCELLED');
2203: AND NOT EXISTS (
2204: SELECT 'Y'
2205: FROM okc_statuses_v okcsts
2206: WHERE okcsts.code = cleb.sts_code
2207: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED'));
2208:
2209: -- Total Fee amount for the rollover fee top line.

Line 2540: FROM okc_statuses_v okcsts

2536: AND cleb.CLE_ID = p_kle_id
2537: -- AND cleb.sts_code NOT IN ('HOLD','EXPIRED','TERMINATED','CANCELLED');
2538: AND NOT EXISTS (
2539: SELECT 'Y'
2540: FROM okc_statuses_v okcsts
2541: WHERE okcsts.code = cleb.sts_code
2542: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED'));
2543:
2544: -- Total Fee amount for the rollover fee top line.