APPS.OKL_DEAL_CREATE_PUB dependencies on OKX_CUSTOMER_ACCOUNTS_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 5727: from okx_customer_accounts_v ca,

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

Line 5733: l_cust_acct_id okx_customer_accounts_v.id1%type := null;

5729: where p.id1 = ca.party_id
5730: and ca.description = p_cust_acc_desc
5731: and p.name = p_name;
5732:
5733: l_cust_acct_id okx_customer_accounts_v.id1%type := null;
5734:
5735: CURSOR l_product_csr IS
5736: SELECT id
5737: FROM OKL_PRODUCTS_V