5565: l_chr_id NUMBER;
5566:
5567: CURSOR l_chk_cust_acc_csr(p_cust_acc_id1 VARCHAR2, p_name VARCHAR2) IS
5568: SELECT COUNT(1)
5569: FROM okx_customer_accounts_v ca, okx_parties_v P
5570: WHERE P.id1 = ca.party_id
5571: AND ca.description = p_cust_acc_id1
5572: AND P.name = p_name;
5573:
5841: l_chr_id NUMBER;
5842:
5843: cursor l_get_cust_id_csr(p_name VARCHAR2) is
5844: select OKX_PARTY.ID1, OKX_PARTY.ID2
5845: from OKX_PARTIES_V OKX_PARTY
5846: where OKX_PARTY.name = p_name
5847: and okx_party.id1 = p_customer_id1;
5848:
5849: l_cust_id1 OKX_PARTIES_V.ID1%type := null;
5845: from OKX_PARTIES_V OKX_PARTY
5846: where OKX_PARTY.name = p_name
5847: and okx_party.id1 = p_customer_id1;
5848:
5849: l_cust_id1 OKX_PARTIES_V.ID1%type := null;
5850: l_cust_id2 OKX_PARTIES_V.ID2%type := null;
5851:
5852: cursor l_get_cust_acc_csr(p_cust_acc_desc VARCHAR2, p_name VARCHAR2) is
5853: select ca.id1
5846: where OKX_PARTY.name = p_name
5847: and okx_party.id1 = p_customer_id1;
5848:
5849: l_cust_id1 OKX_PARTIES_V.ID1%type := null;
5850: l_cust_id2 OKX_PARTIES_V.ID2%type := null;
5851:
5852: cursor l_get_cust_acc_csr(p_cust_acc_desc VARCHAR2, p_name VARCHAR2) is
5853: select ca.id1
5854: from okx_customer_accounts_v ca,
5851:
5852: cursor l_get_cust_acc_csr(p_cust_acc_desc VARCHAR2, p_name VARCHAR2) is
5853: select ca.id1
5854: from okx_customer_accounts_v ca,
5855: okx_parties_v p
5856: where p.id1 = ca.party_id
5857: and ca.description = p_cust_acc_desc
5858: and p.name = p_name;
5859: