APPS.OKS_BILL_UTIL_PUB dependencies on OKC_RULE_GROUPS_B

Line 1889: from okc_rule_groups_b

1885: l_scr_found BOOLEAN := FALSE;
1886: l_top_line_number NUMBER := 0;
1887: cursor rule_group_cur(p_cle_id IN NUMBER) is
1888: select id
1889: from okc_rule_groups_b
1890: where cle_id = p_cle_id;
1891: G_ERROR EXCEPTION;
1892: Begin
1893: If p_target_tbl.COUNT = 0 Then

Line 2565: ,okc_rule_groups_b rgp

2561:
2562: Cursor l_hdr_sbg_csr(p_dnz_chr_id Number) Is
2563: Select nvl(rul.rule_information13,'N')
2564: From okc_rules_b rul
2565: ,okc_rule_groups_b rgp
2566: Where rgp.dnz_chr_id = p_dnz_chr_id
2567: And rgp.id = rul.rgp_id
2568: And rul.rule_information_category = 'SBG';
2569:

Line 3687: OKC_RULE_GROUPS_B RGP

3683: CURSOR L_OKS_LEVEL_ELEMENTS_CSR ( P_LINE_ID in NUMBER ) IS
3684: SELECT LEVL.ID
3685: FROM OKS_LEVEL_ELEMENTS LEVL ,
3686: OKC_RULES_B RULES ,
3687: OKC_RULE_GROUPS_B RGP
3688: WHERE LEVL.RUL_ID = RULES.ID
3689: AND RULES.RGP_ID = RGP.ID
3690: AND RULE_INFORMATION_CATEGORY = 'SLL'
3691: AND RGP.CLE_ID = P_LINE_ID