APPS.OKL_LTE_CHRG_PVT dependencies on OKL_STRM_TYPE_EXEMPT_V

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

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

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

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

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

290: and khr.id = rul_exm.dnz_chr_id
291: and rgp.id = rul_exm.rgp_id
292: and rul_exm.rule_information_category = 'LALCEX'
293: and NVL(rul_exm.rule_information1, 'N') = 'N'
294: and not exists (select 1 from okl_strm_type_exempt_v sty_exm
295: where lte.id = sty_exm.lpo_id
296: and orig_arl.stream_type_id = sty_exm.sty_id
297: and NVL(sty_exm.late_policy_exempt_yn, 'N') = 'Y')
298: and khr.id = rul_hld.dnz_chr_id

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

395: and khr.id = rul_exm.dnz_chr_id
396: and rgp.id = rul_exm.rgp_id
397: and rul_exm.rule_information_category = 'LALCEX'
398: and NVL(rul_exm.rule_information1, 'N') = 'N'
399: and not exists (select 1 from okl_strm_type_exempt_v sty_exm
400: where lte.id = sty_exm.lpo_id
401: and orig.stream_type_id = sty_exm.sty_id
402: and NVL(sty_exm.late_policy_exempt_yn, 'N') = 'Y')
403: and khr.id = rul_hld.dnz_chr_id