DBA Data[Home] [Help]

APPS.OKS_OMINT_PUB dependencies on HZ_CUST_ACCOUNTS

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 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;