DBA Data[Home] [Help]

APPS.OKL_LTE_INT_PVT dependencies on OKL_STRM_TYPE_EXEMPT_V

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

158: and khr.id = rul_exm.dnz_chr_id
159: and rgp.id = rul_exm.rgp_id
160: and rul_exm.rule_information_category = 'LALIEX'
161: and NVL(rul_exm.rule_information1, 'N') = 'N'
162: and not exists (select 1 from okl_strm_type_exempt_v sty_exm
163: where lte.id = sty_exm.lpo_id
164: and TXD.sty_id = sty_exm.sty_id
165: and NVL(sty_exm.late_policy_exempt_yn, 'N') = 'Y')
166: and khr.id = rul_hld.dnz_chr_id

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

233: and khr.id = rul_exm.dnz_chr_id
234: and rgp.id = rul_exm.rgp_id
235: and rul_exm.rule_information_category = 'LALIEX'
236: and NVL(rul_exm.rule_information1, 'N') = 'N'
237: and not exists (select 1 from okl_strm_type_exempt_v sty_exm
238: where lte.id = sty_exm.lpo_id
239: and TXD.sty_id = sty_exm.sty_id
240: and NVL(sty_exm.late_policy_exempt_yn, 'N') = 'Y')
241: and khr.id = rul_hld.dnz_chr_id

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

314: and khr.authoring_org_id = MO_GLOBAL.get_current_org_id
315: and rgp.id = rul_exm.rgp_id
316: and rul_exm.rule_information_category = 'LALIEX'
317: and NVL(rul_exm.rule_information1, 'N') = 'N'
318: and not exists (select 1 from okl_strm_type_exempt_v sty_exm
319: where lte.id = sty_exm.lpo_id
320: and CNSLD.sty_id = sty_exm.sty_id
321: and NVL(sty_exm.late_policy_exempt_yn, 'N') = 'Y')
322: and khr.id = rul_hld.dnz_chr_id