APPS.OKS_BILL_UTIL_PUB dependencies on OKC_RULES_V

Line 52: Select ID Into V_ID From OKC_RULES_V

48: Begin
49: If p_rgp_id is null Then
50: Return(null);
51: Else
52: Select ID Into V_ID From OKC_RULES_V
53: Where rgp_id = p_rgp_id
54: And Rule_information_category = p_rule_type;
55:
56: If v_id Is NULL Then

Line 3204: ,OKC_RULES_V rul

3200:
3201: Cursor l_service_account_csr (p_line_id Number ) IS
3202: Select cst.PARTY_ID||' - '||cst.NAME ServiceAccount
3203: From OKC_RULE_GROUPS_V rgp
3204: ,OKC_RULES_V rul
3205: ,OKX_CUSTOMER_ACCOUNTS_V cst
3206: Where rgp.CLE_ID = p_line_id
3207: and rgp.ID = rul.RGP_ID
3208: and rul.RULE_INFORMATION_CATEGORY = 'CAN'