APPS.OKL_DEAL_CREATE_PUB dependencies on OKX_CUSTOMER_ACCOUNTS_V

Line 5447: FROM okx_customer_accounts_v ca, okx_parties_v P

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

Line 5730: from okx_customer_accounts_v ca,

5726: l_cust_id2 OKX_PARTIES_V.ID2%type := null;
5727:
5728: cursor l_get_cust_acc_csr(p_cust_acc_desc VARCHAR2, p_name VARCHAR2) is
5729: select ca.id1
5730: from okx_customer_accounts_v ca,
5731: okx_parties_v p
5732: where p.id1 = ca.party_id
5733: and ca.description = p_cust_acc_desc
5734: and p.name = p_name;

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

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