DBA Data[Home] [Help]

APPS.OKL_LA_VALIDATION_UTIL_PVT dependencies on OKX_PARTIES_V

Line 61: from okx_parties_v prv

57: select prv.id1,
58: prv.id2,
59: prv.name,
60: prv.description
61: from okx_parties_v prv
62: where prv.name = p_name
63: and prv.id1 = nvl(p_id1,prv.id1)
64: and prv.id2 = nvl(p_id2,prv.id2)
65: order by prv.name

Line 7224: from okx_customer_accounts_v ca, okx_parties_v p

7220: l_currency_code fnd_currencies_vl.currency_code%type := null;
7221:
7222: cursor l_chk_cust_acc_csr(p_cust_acc_id1 VARCHAR2, p_name VARCHAR2) is
7223: select ca.id1
7224: from okx_customer_accounts_v ca, okx_parties_v p
7225: where p.id1 = ca.party_id
7226: and ca.description = p_cust_acc_id1
7227: and p.name = p_name;
7228:

Line 8614: FROM OKX_PARTIES_V OKX_PARTY

8610: CURSOR party_csr IS
8611:
8612: select '1'
8613:
8614: FROM OKX_PARTIES_V OKX_PARTY
8615:
8616: WHERE ID1 = p_id1
8617:
8618: AND ID2 = p_id2;