DBA Data[Home] [Help]

APPS.OKS_BILL_UTIL_PUB dependencies on OKX_CUSTOMER_ACCOUNTS_V

Line 2718: From OKX_CUSTOMER_ACCOUNTS_V

2714: And id2 = p_object1_id2 ;
2715:
2716: Cursor l_cust_acct(p_object1_id1 Number, p_object1_id2 Varchar2) IS
2717: Select name
2718: From OKX_CUSTOMER_ACCOUNTS_V
2719: Where id1 = p_object1_id1
2720: And id2 = p_object1_id2 ;
2721:
2722: --start bug#4928081 mchoudha replaced this cursor with the following

Line 3205: ,OKX_CUSTOMER_ACCOUNTS_V cst

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