APPS.OKL_INTEREST_CALC_PVT dependencies on OKC_RULE_GROUPS_B

Line 152: from okc_rule_groups_b rgp

148: SELECT object1_id1 cust_acct_site_id
149: FROM okc_rules_b rul
150: WHERE rul.rule_information_category = 'BTO'
151: and exists (select '1'
152: from okc_rule_groups_b rgp
153: where rgp.id = rul.rgp_id
154: and rgp.rgd_code = 'LABILL'
155: and rgp.chr_id = rul.dnz_chr_id
156: and rgp.chr_id = v_khr_id );

Line 366: FROM OKC_RULES_B rule, OKL_INDICES idx, OKC_RULE_GROUPS_B rgp

362: -- Modified cursor to fetch Index Name from Prefunding Terms
363: -- and Conditions
364: CURSOR indx_csr(p_chr_id IN NUMBER) IS
365: SELECT idx.name
366: FROM OKC_RULES_B rule, OKL_INDICES idx, OKC_RULE_GROUPS_B rgp
367: WHERE rule.rule_information_category = 'LAIVAR'
368: AND rule.dnz_chr_id = p_chr_id
369: AND rule.rule_information2 = idx.id
370: AND rule.rgp_id = rgp.id