DBA Data[Home] [Help]

APPS.OKL_LA_VALIDATION_UTIL_PVT dependencies on OKX_PARTY_CONTACTS_V

Line 47: FROM okx_party_contacts_v pcv

43: SELECT pcv.ID1,
44: pcv.ID2,
45: pcv.NAME,
46: pcv.DESCRIPTION
47: FROM okx_party_contacts_v pcv
48: WHERE pcv.name = NVL(p_name,pcv.name)
49: AND pcv.ID1 = NVL(p_id1,pcv.ID1)
50: AND pcv.ID2 = NVL(p_id2,pcv.ID2)
51: ORDER BY pcv.NAME;

Line 8862: OKX_PARTY_CONTACTS_V OKX_PCONTACT

8858: CURSOR pcontact_csr IS
8859:
8860: select '1' from
8861:
8862: OKX_PARTY_CONTACTS_V OKX_PCONTACT
8863:
8864: WHERE ID1 = p_id1
8865:
8866: AND ID2 = p_id2;