APPS.OKL_LTE_CHRG_PVT dependencies on OKL_STRM_TYPE_EXEMPT_V

Line 143: and not exists (select 1 from okl_strm_type_exempt_v sty_exm

139: and khr.id = rul_exm.dnz_chr_id
140: and rgp.id = rul_exm.rgp_id
141: and rul_exm.rule_information_category = 'LALCEX'
142: and NVL(rul_exm.rule_information1, 'N') = 'N'
143: and not exists (select 1 from okl_strm_type_exempt_v sty_exm
144: where lte.id = sty_exm.lpo_id
145: and lpt1.stream_type_id = sty_exm.sty_id
146: and NVL(sty_exm.late_policy_exempt_yn, 'N') = 'Y')
147: and khr.id = rul_hld.dnz_chr_id

Line 203: and not exists (select 1 from okl_strm_type_exempt_v sty_exm

199: and khr.id = rul_exm.dnz_chr_id
200: and rgp.id = rul_exm.rgp_id
201: and rul_exm.rule_information_category = 'LALCEX'
202: and NVL(rul_exm.rule_information1, 'N') = 'N'
203: and not exists (select 1 from okl_strm_type_exempt_v sty_exm
204: where lte.id = sty_exm.lpo_id
205: and SM.id = sty_exm.sty_id
206: and NVL(sty_exm.late_policy_exempt_yn, 'N') = 'Y')
207: and khr.id = rul_hld.dnz_chr_id

Line 289: and not exists (select 1 from okl_strm_type_exempt_v sty_exm

285: and khr.id = rul_exm.dnz_chr_id
286: and rgp.id = rul_exm.rgp_id
287: and rul_exm.rule_information_category = 'LALCEX'
288: and NVL(rul_exm.rule_information1, 'N') = 'N'
289: and not exists (select 1 from okl_strm_type_exempt_v sty_exm
290: where lte.id = sty_exm.lpo_id
291: and orig_arl.stream_type_id = sty_exm.sty_id
292: and NVL(sty_exm.late_policy_exempt_yn, 'N') = 'Y')
293: and khr.id = rul_hld.dnz_chr_id

Line 394: and not exists (select 1 from okl_strm_type_exempt_v sty_exm

390: and khr.id = rul_exm.dnz_chr_id
391: and rgp.id = rul_exm.rgp_id
392: and rul_exm.rule_information_category = 'LALCEX'
393: and NVL(rul_exm.rule_information1, 'N') = 'N'
394: and not exists (select 1 from okl_strm_type_exempt_v sty_exm
395: where lte.id = sty_exm.lpo_id
396: and orig.stream_type_id = sty_exm.sty_id
397: and NVL(sty_exm.late_policy_exempt_yn, 'N') = 'Y')
398: and khr.id = rul_hld.dnz_chr_id