APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKC_RULE_GROUPS_B

Line 22442: FROM okc_rule_groups_b rgp

22438: --Bug# 6112766:Start
22439: CURSOR get_rule_group_info(p_chr_id okc_k_headers_b.id%TYPE,
22440: p_cle_id okc_k_lines_v.id%TYPE) IS
22441: SELECT rgp.id
22442: FROM okc_rule_groups_b rgp
22443: WHERE rgp.dnz_chr_id = p_chr_id
22444: AND rgp.cle_id = p_cle_id
22445: AND rgp.rgd_code = 'LALEVL'
22446: AND rgp.rgp_type = 'KRG';

Line 27639: FROM okc_rule_groups_b rgp,

27635:
27636: CURSOR l_var_int_sched_csr(p_chr_id IN NUMBER) IS
27637: SELECT rgp.id rgp_id,
27638: slh.id slh_id
27639: FROM okc_rule_groups_b rgp,
27640: okc_rules_b slh,
27641: okl_strm_type_b sty
27642: WHERE rgp.chr_id = p_chr_id
27643: AND rgp.dnz_chr_id = p_chr_id