DBA Data[Home] [Help]

APPS.OKL_BPD_TERMINATION_ADJ_PVT dependencies on OKC_RULES_B

Line 797: , okc_rules_b rul

793: AND stm.kle_id = kle.id(+)
794: AND nvl(stm.kle_id, -99) = nvl(cp_kle_id, nvl(stm.kle_id, -99))
795: AND OKL_BPD_TERMINATION_ADJ_PVT.get_kle_status_code(stm.kle_id) IN ('ACTIVE', 'TERMINATED', 'HEADER_LEVEL')
796: AND exists (select 1 from okc_rule_groups_b rgp
797: , okc_rules_b rul
798: where rgp.dnz_chr_id = kle.dnz_chr_id
799: and rgp.cle_id = kle.id
800: and rgp.rgd_code = 'LAASTX'
801: and rgp.id = rul.rgp_id