APPS.OKL_QA_DATA_INTEGRITY dependencies on OKC_STATUSES_V

Line 3456: okc_statuses_v sts,

3452: pph.passthru_term,
3453: pph.passthru_stream_type_id
3454: FROM okl_k_lines_full_v line,
3455: okc_line_styles_v style,
3456: okc_statuses_v sts,
3457: okl_party_payment_hdr pph
3458: WHERE line.lse_id = style.id
3459: AND line.sts_code = sts.code
3460: AND sts.ste_code NOT IN ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED')

Line 3494: okc_statuses_v sts,

3490: rule.object1_id1,
3491: style.name line_style
3492: FROM okl_k_lines_full_v line,
3493: okc_line_styles_v style,
3494: okc_statuses_v sts,
3495: okc_rule_groups_b rgp,
3496: okc_rules_b rule
3497: WHERE rgp.id = rule.rgp_id
3498: AND line.id = rgp.cle_id

Line 5789: okc_statuses_v sts

5785: l.capital_amount,
5786: l.fee_type
5787: FROM okl_k_lines_full_v l,
5788: okc_line_styles_v sty,
5789: okc_statuses_v sts
5790: WHERE l.lse_id = sty.id
5791: AND l.sts_code = sts.code
5792: AND sts.ste_code NOT IN ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED')
5793: AND sty.lty_code = 'FEE'

Line 6157: FROM okc_statuses_v okcsts

6153: AND kle.fee_type = 'ROLLOVER'
6154: -- AND cleb.sts_code NOT IN ('HOLD','EXPIRED','TERMINATED','CANCELLED', 'ABANDONED');
6155: AND NOT EXISTS (
6156: SELECT 'Y'
6157: FROM okc_statuses_v okcsts
6158: WHERE okcsts.code = cleb.sts_code
6159: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED', 'ABANDONED'));
6160:
6161:

Line 6175: FROM okc_statuses_v okcsts

6171: AND kle.fee_type = 'ROLLOVER'
6172: -- AND cleb.sts_code NOT IN ('HOLD','EXPIRED','TERMINATED','CANCELLED', 'ABANDONED');
6173: AND NOT EXISTS (
6174: SELECT 'Y'
6175: FROM okc_statuses_v okcsts
6176: WHERE okcsts.code = cleb.sts_code
6177: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED', 'ABANDONED'));
6178:
6179:

Line 6194: FROM okc_statuses_v okcsts

6190: AND cleb.CLE_ID = feeTopLine
6191: -- AND cleb.sts_code NOT IN ('HOLD','EXPIRED','TERMINATED','CANCELLED', 'ABANDONED');
6192: AND NOT EXISTS (
6193: SELECT 'Y'
6194: FROM okc_statuses_v okcsts
6195: WHERE okcsts.code = cleb.sts_code
6196: --Bug# 4959361: Include Terminated lines when fetching sub-line amount
6197: --AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED', 'ABANDONED'));
6198: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','ABANDONED'));

Line 7387: FROM okc_statuses_v okcsts

7383: AND rgp.cle_id is not null
7384: AND cleb.lse_id = 33
7385: AND NOT EXISTS (
7386: SELECT 'Y'
7387: FROM okc_statuses_v okcsts
7388: WHERE okcsts.code = cleb.sts_code
7389: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED', 'ABANDONED'));
7390:
7391: CURSOR get_line_amt (p_id IN NUMBER) IS