APPS.OKS_BILL_REC_PUB dependencies on OKC_RULES_B

Line 2044: p_freq okc_rules_b.object1_id1%TYPE;

2040: WHERE id = p_id;
2041:
2042:
2043: cur_rec get_current_period_amount%ROWTYPE;
2044: p_freq okc_rules_b.object1_id1%TYPE;
2045:
2046: l_amount NUMBER;
2047: l_diff NUMBER;
2048: l_id NUMBER;

Line 7687: From OKC_RULES_B RL

7683: ) IS
7684:
7685: Cursor l_bill_profile_id_csr(id_in IN Number) IS
7686: Select rule_information1 profile_id
7687: From OKC_RULES_B RL
7688: ,OKC_RULE_GROUPS_B RG
7689: Where RG.dnz_chr_id = id_in
7690: And RG.cle_id Is Null
7691: And RG.id = RL.rgp_id

Line 7754: OKC_RULES_B rules,

7750: rules.rule_information8 Secondary_period
7751:
7752: From OKC_K_LINES_B line,
7753: OKC_K_HEADERS_B Hdr,
7754: OKC_RULES_B rules,
7755: OKC_RULE_GROUPS_B rlgrp
7756:
7757: Where line.lse_id in (1,12)
7758: And line.dnz_chr_id = Hdr.id

Line 7812: From OKC_RULES_B RL,

7808:
7809: Cursor l_usage_csr(p_id Number)
7810: Is
7811: Select Rule_information10 Usage_Type
7812: From OKC_RULES_B RL,
7813: OKC_RULE_GROUPS_B RG
7814: Where RG.cle_id = p_id
7815: And RG.id = RL.rgp_id
7816: And rule_information_category = 'QRE';