APPS.OKL_DEAL_CREATE_PUB dependencies on OKX_PARTIES_V

Line 5444: FROM okx_customer_accounts_v ca, okx_parties_v P

5440: l_chr_id NUMBER;
5441:
5442: CURSOR l_chk_cust_acc_csr(p_cust_acc_id1 VARCHAR2, p_name VARCHAR2) IS
5443: SELECT COUNT(1)
5444: FROM okx_customer_accounts_v ca, okx_parties_v P
5445: WHERE P.id1 = ca.party_id
5446: AND ca.description = p_cust_acc_id1
5447: AND P.name = p_name;
5448:

Line 5718: from OKX_PARTIES_V OKX_PARTY

5714: l_chr_id NUMBER;
5715:
5716: cursor l_get_cust_id_csr(p_name VARCHAR2) is
5717: select OKX_PARTY.ID1, OKX_PARTY.ID2
5718: from OKX_PARTIES_V OKX_PARTY
5719: where OKX_PARTY.name = p_name
5720: and okx_party.id1 = p_customer_id1;
5721:
5722: l_cust_id1 OKX_PARTIES_V.ID1%type := null;

Line 5722: l_cust_id1 OKX_PARTIES_V.ID1%type := null;

5718: from OKX_PARTIES_V OKX_PARTY
5719: where OKX_PARTY.name = p_name
5720: and okx_party.id1 = p_customer_id1;
5721:
5722: l_cust_id1 OKX_PARTIES_V.ID1%type := null;
5723: l_cust_id2 OKX_PARTIES_V.ID2%type := null;
5724:
5725: cursor l_get_cust_acc_csr(p_cust_acc_desc VARCHAR2, p_name VARCHAR2) is
5726: select ca.id1

Line 5723: l_cust_id2 OKX_PARTIES_V.ID2%type := null;

5719: where OKX_PARTY.name = p_name
5720: and okx_party.id1 = p_customer_id1;
5721:
5722: l_cust_id1 OKX_PARTIES_V.ID1%type := null;
5723: l_cust_id2 OKX_PARTIES_V.ID2%type := null;
5724:
5725: cursor l_get_cust_acc_csr(p_cust_acc_desc VARCHAR2, p_name VARCHAR2) is
5726: select ca.id1
5727: from okx_customer_accounts_v ca,

Line 5728: okx_parties_v p

5724:
5725: cursor l_get_cust_acc_csr(p_cust_acc_desc VARCHAR2, p_name VARCHAR2) is
5726: select ca.id1
5727: from okx_customer_accounts_v ca,
5728: okx_parties_v p
5729: where p.id1 = ca.party_id
5730: and ca.description = p_cust_acc_desc
5731: and p.name = p_name;
5732: