DBA Data[Home] [Help]

APPS.OKS_BILL_UTIL_PUB dependencies on OKX_CUSTOMER_ACCOUNTS_V

Line 2752: From OKX_CUSTOMER_ACCOUNTS_V

2748: And id2 = p_object1_id2 ;
2749:
2750: Cursor l_cust_acct(p_object1_id1 Number, p_object1_id2 Varchar2) IS
2751: Select name
2752: From OKX_CUSTOMER_ACCOUNTS_V
2753: Where id1 = p_object1_id1
2754: And id2 = p_object1_id2 ;
2755:
2756: --start bug#4928081 mchoudha replaced this cursor with the following

Line 3239: ,OKX_CUSTOMER_ACCOUNTS_V cst

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'
3243: and cst.ID1 = rul.OBJECT1_ID1