APPS.OKS_IB_UTIL_PVT dependencies on OKX_CUSTOMER_ACCOUNTS_V

Line 1156: From OKX_CUSTOMER_ACCOUNTS_V

1152: and trunc(p_transfer_date) between trunc(start_date) and trunc(end_date)
1153: ;
1154: Cursor l_party_csr(p_cust_id Number) Is
1155: Select party_id
1156: From OKX_CUSTOMER_ACCOUNTS_V
1157: Where id1 = p_cust_id;
1158:
1159: Cursor l_instance_csr Is
1160: Select owner_party_id

Line 1257: From OKX_CUSTOMER_ACCOUNTS_V

1253: and trunc(p_transfer_date) between trunc(start_date) and trunc(end_date)
1254: ;
1255: Cursor l_party_csr(p_cust_id Number) Is
1256: Select party_id
1257: From OKX_CUSTOMER_ACCOUNTS_V
1258: Where id1 = p_cust_id;
1259:
1260: Cursor l_instance_csr Is
1261: Select owner_party_id

Line 1331: From OKX_CUSTOMER_ACCOUNTS_V

1327: and trunc(p_transfer_date) between trunc(start_date) and trunc(end_date)
1328: ;
1329: Cursor l_party_csr(p_cust_id Number) Is
1330: Select party_id
1331: From OKX_CUSTOMER_ACCOUNTS_V
1332: Where id1 = p_cust_id;
1333:
1334: Cursor l_instance_csr Is
1335: Select owner_party_id

Line 2283: FROM okx_customer_accounts_v

2279: p_cust_id NUMBER
2280: )
2281: IS
2282: SELECT party_id
2283: FROM okx_customer_accounts_v
2284: WHERE id1 = p_cust_id;
2285:
2286: l_new_party_id NUMBER;
2287: l_old_party_id NUMBER;