APPS.OKL_QA_DATA_INTEGRITY dependencies on OKC_STATUSES_V

Line 3271: okc_statuses_v sts,

3267: pph.passthru_term,
3268: pph.passthru_stream_type_id
3269: FROM okl_k_lines_full_v line,
3270: okc_line_styles_v style,
3271: okc_statuses_v sts,
3272: okl_party_payment_hdr pph
3273: WHERE line.lse_id = style.id
3274: AND line.sts_code = sts.code
3275: AND sts.ste_code NOT IN ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED')

Line 3309: okc_statuses_v sts,

3305: rule.object1_id1,
3306: style.name line_style
3307: FROM okl_k_lines_full_v line,
3308: okc_line_styles_v style,
3309: okc_statuses_v sts,
3310: okc_rule_groups_b rgp,
3311: okc_rules_b rule
3312: WHERE rgp.id = rule.rgp_id
3313: AND line.id = rgp.cle_id

Line 5402: okc_statuses_v sts

5398: l.capital_amount,
5399: l.fee_type
5400: FROM okl_k_lines_full_v l,
5401: okc_line_styles_v sty,
5402: okc_statuses_v sts
5403: WHERE l.lse_id = sty.id
5404: AND l.sts_code = sts.code
5405: AND sts.ste_code NOT IN ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED')
5406: AND sty.lty_code = 'FEE'

Line 5770: FROM okc_statuses_v okcsts

5766: AND kle.fee_type = 'ROLLOVER'
5767: -- AND cleb.sts_code NOT IN ('HOLD','EXPIRED','TERMINATED','CANCELLED', 'ABANDONED');
5768: AND NOT EXISTS (
5769: SELECT 'Y'
5770: FROM okc_statuses_v okcsts
5771: WHERE okcsts.code = cleb.sts_code
5772: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED', 'ABANDONED'));
5773:
5774:

Line 5788: FROM okc_statuses_v okcsts

5784: AND kle.fee_type = 'ROLLOVER'
5785: -- AND cleb.sts_code NOT IN ('HOLD','EXPIRED','TERMINATED','CANCELLED', 'ABANDONED');
5786: AND NOT EXISTS (
5787: SELECT 'Y'
5788: FROM okc_statuses_v okcsts
5789: WHERE okcsts.code = cleb.sts_code
5790: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED', 'ABANDONED'));
5791:
5792:

Line 5807: FROM okc_statuses_v okcsts

5803: AND cleb.CLE_ID = feeTopLine
5804: -- AND cleb.sts_code NOT IN ('HOLD','EXPIRED','TERMINATED','CANCELLED', 'ABANDONED');
5805: AND NOT EXISTS (
5806: SELECT 'Y'
5807: FROM okc_statuses_v okcsts
5808: WHERE okcsts.code = cleb.sts_code
5809: --Bug# 4959361: Include Terminated lines when fetching sub-line amount
5810: --AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED', 'ABANDONED'));
5811: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','ABANDONED'));

Line 7000: FROM okc_statuses_v okcsts

6996: AND rgp.cle_id is not null
6997: AND cleb.lse_id = 33
6998: AND NOT EXISTS (
6999: SELECT 'Y'
7000: FROM okc_statuses_v okcsts
7001: WHERE okcsts.code = cleb.sts_code
7002: AND okcsts.ste_code IN ('EXPIRED','HOLD','CANCELLED','TERMINATED', 'ABANDONED'));
7003:
7004: CURSOR get_line_amt (p_id IN NUMBER) IS