DBA Data[Home] [Help]

APPS.OKL_LTE_INT_PVT dependencies on OKL_STRM_TYPE_EXEMPT_V

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

132: and khr.id = rul_exm.dnz_chr_id
133: and rgp.id = rul_exm.rgp_id
134: and rul_exm.rule_information_category = 'LALIEX'
135: and NVL(rul_exm.rule_information1, 'N') = 'N'
136: and not exists (select 1 from okl_strm_type_exempt_v sty_exm
137: where lte.id = sty_exm.lpo_id
138: and ARL.sty_id = sty_exm.sty_id
139: and NVL(sty_exm.late_policy_exempt_yn, 'N') = 'Y')
140: and khr.id = rul_hld.dnz_chr_id

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

193: and khr.authoring_org_id = MO_GLOBAL.get_current_org_id
194: and rgp.id = rul_exm.rgp_id
195: and rul_exm.rule_information_category = 'LALIEX'
196: and NVL(rul_exm.rule_information1, 'N') = 'N'
197: and not exists (select 1 from okl_strm_type_exempt_v sty_exm
198: where lte.id = sty_exm.lpo_id
199: and CNSLD.sty_id = sty_exm.sty_id
200: and NVL(sty_exm.late_policy_exempt_yn, 'N') = 'Y')
201: and khr.id = rul_hld.dnz_chr_id