APPS.OKS_BILL_UTIL_PUB dependencies on OKC_RULES_B

Line 1366: from okc_rules_b rul

1362: i NUMBER := 1;
1363:
1364: cursor rule_csr Is
1365: select rul.id
1366: from okc_rules_b rul
1367: where rul.rule_information_category in ('IRE') and
1368: dnz_chr_id = p_chr_id;
1369:
1370: p_rulv_tbl OKC_RULE_PUB.rulv_tbl_type;

Line 1760: from okc_rules_b

1756: p_info3 IN NUMBER,
1757: x_status OUT NOCOPY VARCHAR2) is
1758: cursor rule_cur is
1759: select id
1760: from okc_rules_b
1761: where rgp_id = p_rgp_id
1762: and rule_information_category = 'USV';
1763: l_rule_id NUMBER;
1764: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;

Line 2564: From okc_rules_b rul

2560: )Return Varchar2 IS
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';

Line 3686: OKC_RULES_B RULES ,

3682:
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'