DBA Data[Home] [Help]

APPS.OKS_BILL_REC_PUB dependencies on OKC_RULE_GROUPS_B

Line 7688: ,OKC_RULE_GROUPS_B RG

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
7692: And rule_information_category = 'BPF';

Line 7755: OKC_RULE_GROUPS_B rlgrp

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
7759: And rlgrp.cle_id = line.id

Line 7813: OKC_RULE_GROUPS_B RG

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';
7817: