DBA Data[Home] [Help]

APPS.OKL_LA_VALIDATION_UTIL_PVT dependencies on OKX_PARTIES_V

Line 45: from okx_parties_v prv

41: select prv.id1,
42: prv.id2,
43: prv.name,
44: prv.description
45: from okx_parties_v prv
46: where prv.name = p_name
47: and prv.id1 = nvl(p_id1,prv.id1)
48: and prv.id2 = nvl(p_id2,prv.id2)
49: order by prv.name

Line 7208: from okx_customer_accounts_v ca, okx_parties_v p

7204: l_currency_code fnd_currencies_vl.currency_code%type := null;
7205:
7206: cursor l_chk_cust_acc_csr(p_cust_acc_id1 VARCHAR2, p_name VARCHAR2) is
7207: select ca.id1
7208: from okx_customer_accounts_v ca, okx_parties_v p
7209: where p.id1 = ca.party_id
7210: and ca.description = p_cust_acc_id1
7211: and p.name = p_name;
7212:

Line 8552: FROM OKX_PARTIES_V OKX_PARTY

8548: CURSOR party_csr IS
8549:
8550: select '1'
8551:
8552: FROM OKX_PARTIES_V OKX_PARTY
8553:
8554: WHERE ID1 = p_id1
8555:
8556: AND ID2 = p_id2;