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 3238: ,OKC_RULES_V rul

3234:
3235: Cursor l_service_account_csr (p_line_id Number ) IS
3236: Select cst.PARTY_ID||' - '||cst.NAME ServiceAccount
3237: From OKC_RULE_GROUPS_V rgp
3238: ,OKC_RULES_V rul
3239: ,OKX_CUSTOMER_ACCOUNTS_V cst
3240: Where rgp.CLE_ID = p_line_id
3241: and rgp.ID = rul.RGP_ID
3242: and rul.RULE_INFORMATION_CATEGORY = 'CAN'