APPS.OKS_BILL_REC_PUB dependencies on OKC_RULES_B

Line 2058: p_freq okc_rules_b.object1_id1%TYPE;

2054: WHERE id = p_id;
2055:
2056:
2057: cur_rec get_current_period_amount%ROWTYPE;
2058: p_freq okc_rules_b.object1_id1%TYPE;
2059:
2060: l_amount NUMBER;
2061: l_diff NUMBER;
2062: l_id NUMBER;

Line 7719: From OKC_RULES_B RL

7715: ) IS
7716:
7717: Cursor l_bill_profile_id_csr(id_in IN Number) IS
7718: Select rule_information1 profile_id
7719: From OKC_RULES_B RL
7720: ,OKC_RULE_GROUPS_B RG
7721: Where RG.dnz_chr_id = id_in
7722: And RG.cle_id Is Null
7723: And RG.id = RL.rgp_id

Line 7786: OKC_RULES_B rules,

7782: rules.rule_information8 Secondary_period
7783:
7784: From OKC_K_LINES_B line,
7785: OKC_K_HEADERS_B Hdr,
7786: OKC_RULES_B rules,
7787: OKC_RULE_GROUPS_B rlgrp
7788:
7789: Where line.lse_id in (1,12)
7790: And line.dnz_chr_id = Hdr.id

Line 7844: From OKC_RULES_B RL,

7840:
7841: Cursor l_usage_csr(p_id Number)
7842: Is
7843: Select Rule_information10 Usage_Type
7844: From OKC_RULES_B RL,
7845: OKC_RULE_GROUPS_B RG
7846: Where RG.cle_id = p_id
7847: And RG.id = RL.rgp_id
7848: And rule_information_category = 'QRE';