APPS.OKS_BILL_UTIL_PUB dependencies on OKC_RULE_GROUPS_B

Line 1923: from okc_rule_groups_b

1919: l_scr_found BOOLEAN := FALSE;
1920: l_top_line_number NUMBER := 0;
1921: cursor rule_group_cur(p_cle_id IN NUMBER) is
1922: select id
1923: from okc_rule_groups_b
1924: where cle_id = p_cle_id;
1925: G_ERROR EXCEPTION;
1926: Begin
1927: If p_target_tbl.COUNT = 0 Then

Line 2599: ,okc_rule_groups_b rgp

2595:
2596: Cursor l_hdr_sbg_csr(p_dnz_chr_id Number) Is
2597: Select nvl(rul.rule_information13,'N')
2598: From okc_rules_b rul
2599: ,okc_rule_groups_b rgp
2600: Where rgp.dnz_chr_id = p_dnz_chr_id
2601: And rgp.id = rul.rgp_id
2602: And rul.rule_information_category = 'SBG';
2603:

Line 3722: OKC_RULE_GROUPS_B RGP

3718: CURSOR L_OKS_LEVEL_ELEMENTS_CSR ( P_LINE_ID in NUMBER ) IS
3719: SELECT LEVL.ID
3720: FROM OKS_LEVEL_ELEMENTS LEVL ,
3721: OKC_RULES_B RULES ,
3722: OKC_RULE_GROUPS_B RGP
3723: WHERE LEVL.RUL_ID = RULES.ID
3724: AND RULES.RGP_ID = RGP.ID
3725: AND RULE_INFORMATION_CATEGORY = 'SLL'
3726: AND RGP.CLE_ID = P_LINE_ID