APPS.OKL_DEAL_CREAT_PVT dependencies on OKX_PARTIES_V

Line 5544: FROM okx_customer_accounts_v ca, okx_parties_v P

5540: l_chr_id NUMBER;
5541:
5542: CURSOR l_chk_cust_acc_csr(p_cust_acc_id1 VARCHAR2, p_name VARCHAR2) IS
5543: SELECT COUNT(1)
5544: FROM okx_customer_accounts_v ca, okx_parties_v P
5545: WHERE P.id1 = ca.party_id
5546: AND ca.description = p_cust_acc_id1
5547: AND P.name = p_name;
5548:

Line 5819: from OKX_PARTIES_V OKX_PARTY

5815: l_chr_id NUMBER;
5816:
5817: cursor l_get_cust_id_csr(p_name VARCHAR2) is
5818: select OKX_PARTY.ID1, OKX_PARTY.ID2
5819: from OKX_PARTIES_V OKX_PARTY
5820: where OKX_PARTY.name = p_name
5821: and okx_party.id1 = p_customer_id1;
5822:
5823: l_cust_id1 OKX_PARTIES_V.ID1%type := null;

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

5819: from OKX_PARTIES_V OKX_PARTY
5820: where OKX_PARTY.name = p_name
5821: and okx_party.id1 = p_customer_id1;
5822:
5823: l_cust_id1 OKX_PARTIES_V.ID1%type := null;
5824: l_cust_id2 OKX_PARTIES_V.ID2%type := null;
5825:
5826: cursor l_get_cust_acc_csr(p_cust_acc_desc VARCHAR2, p_name VARCHAR2) is
5827: select ca.id1

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

5820: where OKX_PARTY.name = p_name
5821: and okx_party.id1 = p_customer_id1;
5822:
5823: l_cust_id1 OKX_PARTIES_V.ID1%type := null;
5824: l_cust_id2 OKX_PARTIES_V.ID2%type := null;
5825:
5826: cursor l_get_cust_acc_csr(p_cust_acc_desc VARCHAR2, p_name VARCHAR2) is
5827: select ca.id1
5828: from okx_customer_accounts_v ca,

Line 5829: okx_parties_v p

5825:
5826: cursor l_get_cust_acc_csr(p_cust_acc_desc VARCHAR2, p_name VARCHAR2) is
5827: select ca.id1
5828: from okx_customer_accounts_v ca,
5829: okx_parties_v p
5830: where p.id1 = ca.party_id
5831: and ca.description = p_cust_acc_desc
5832: and p.name = p_name;
5833: