APPS.OKS_BILL_UTIL_PUB dependencies on OKC_RULE_GROUPS_V

Line 15: SELECT ID INTO V_ID FROM OKC_RULE_GROUPS_V WHERE Dnz_CHR_ID = p_chr_id And cle_id Is Null;

11: Is
12: v_id NUMBER;
13: Begin
14: If (p_chr_id IS NOT NULL) Then
15: SELECT ID INTO V_ID FROM OKC_RULE_GROUPS_V WHERE Dnz_CHR_ID = p_chr_id And cle_id Is Null;
16: If V_ID IS NULL Then
17: return(NULL);
18: Else
19: return(V_ID);

Line 24: SELECT ID INTO V_ID FROM OKC_RULE_GROUPS_V WHERE CLE_ID = p_cle_id;

20: End If;
21: End If;
22:
23: If (p_cle_id IS NOT NULL) Then
24: SELECT ID INTO V_ID FROM OKC_RULE_GROUPS_V WHERE CLE_ID = p_cle_id;
25: If V_ID IS NULL Then
26: return(NULL);
27: Else
28: return(V_ID);

Line 3237: From OKC_RULE_GROUPS_V rgp

3233: and rownum < 2 ;
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