DBA Data[Home] [Help]

APPS.OKL_CONTRACT_INFO dependencies on OKC_RULES_B

Line 271: FROM okc_rule_groups_b rgp, okc_rules_b rul

267:
268: -- Following cursor introduced for bug: 3838403
269: CURSOR get_non_notify_flag (p_contract_id IN NUMBER) IS
270: SELECT RULE_INFORMATION1
271: FROM okc_rule_groups_b rgp, okc_rules_b rul
272: WHERE rgp.id = rul.rgp_id
273: AND rgp.dnz_chr_id = p_contract_id
274: AND rgp.rgd_code = 'LANNTF'
275: AND rul.rule_information_category = 'LANNTF';