APPS.OKS_ATTR_DEFAULTS_PVT dependencies on OKX_CUSTOMER_ACCOUNTS_V

Line 283: FROM okx_customer_accounts_v

279: l_msg_index NUMBER;
280:
281: CURSOR get_party(p_can_id in number) IS
282: SELECT party_id
283: FROM okx_customer_accounts_v
284: WHERE id1=p_can_id;
285: l_party_id NUMBER;
286:
287: CURSOR role_csr IS

Line 674: FROM okx_cust_site_uses_v a, okx_customer_accounts_v b

670:
671: -- GET CUST ACCT --
672: CURSOR CUR_CUST_ACCT (l_object1_id1 IN NUMBER,use IN VARCHAR2) IS
673: SELECT DISTINCT b.id1, a.party_id
674: FROM okx_cust_site_uses_v a, okx_customer_accounts_v b
675: WHERE a.id1 = l_object1_id1
676: AND b.id1 = a.cust_account_id
677: AND a.site_use_code = use;
678:

Line 705: from okx_customer_accounts_v

701: AND OBJECT1_ID1 =l_party_id;
702:
703: Cursor Get_Party_Id (p_cust_acct_id IN NUMBER) IS
704: Select Party_id,name
705: from okx_customer_accounts_v
706: where id1= p_cust_acct_id;
707:
708:
709: