DBA Data[Home] [Help]

APPS.OKS_BILL_REC_PUB dependencies on OKC_RULE_GROUPS_B

Line 7720: ,OKC_RULE_GROUPS_B RG

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

Line 7787: OKC_RULE_GROUPS_B rlgrp

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

Line 7845: OKC_RULE_GROUPS_B RG

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