APPS.OKS_OMINT_PUB dependencies on OKX_CUSTOMER_ACCOUNTS_V

Line 40: From HZ_CUST_ACCOUNTS --OKX_CUSTOMER_ACCOUNTS_V

36: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
37:
38: Cursor l_Customer_Coterm_Csr is
39: Select Coterminate_Day_Month
40: From HZ_CUST_ACCOUNTS --OKX_CUSTOMER_ACCOUNTS_V
41: Where CUST_ACCOUNT_ID = p_customer_id;
42:
43: Cursor l_System_Coterm_Csr is
44: Select Coterminate_Day_Month

Line 282: Select Party_Id From OKX_CUSTOMER_ACCOUNTS_V

278: And Except_Object_type = Nvl(obj_type,Except_Object_type)
279: Order By Except_Object_type;
280:
281: Cursor l_party_csr (l_custid Number) Is
282: Select Party_Id From OKX_CUSTOMER_ACCOUNTS_V
283: Where Id1 = l_custid;
284:
285: Cursor l_cp_status_csr Is
286: Select distinct SERVICE_ORDER_ALLOWED_FLAG

Line 749: Select Party_Id From OKX_CUSTOMER_ACCOUNTS_V

745:
746:
747:
748: Cursor l_party_csr (l_custid Number) Is
749: Select Party_Id From OKX_CUSTOMER_ACCOUNTS_V
750: Where Id1 = l_custid;
751:
752:
753: l_party_id Number;

Line 952: Select Party_Id From HZ_CUST_ACCOUNTS -- OKX_CUSTOMER_ACCOUNTS_V

948: AND B.ORGANIZATION_ID = v_organization_id;
949: --end 4897884
950:
951: Cursor l_party_csr (l_custid Number) Is
952: Select Party_Id From HZ_CUST_ACCOUNTS -- OKX_CUSTOMER_ACCOUNTS_V
953: Where CUST_ACCOUNT_ID = l_custid;
954:
955:
956: l_party_id Number;

Line 2099: Select Party_Id From OKX_CUSTOMER_ACCOUNTS_V

2095: AND fnd1.language = USERENV('LANG')
2096: ORDER BY CONCATENATED_SEGMENTS;
2097:
2098: Cursor l_party_csr (l_custid Number) Is
2099: Select Party_Id From OKX_CUSTOMER_ACCOUNTS_V
2100: Where Id1 = l_custid;
2101:
2102: l_party_id Number;
2103: