APPS.OKL_LA_VALIDATION_UTIL_PVT dependencies on OKX_PARTY_CONTACTS_V

Line 31: FROM okx_party_contacts_v pcv

27: SELECT pcv.ID1,
28: pcv.ID2,
29: pcv.NAME,
30: pcv.DESCRIPTION
31: FROM okx_party_contacts_v pcv
32: WHERE pcv.name = NVL(p_name,pcv.name)
33: AND pcv.ID1 = NVL(p_id1,pcv.ID1)
34: AND pcv.ID2 = NVL(p_id2,pcv.ID2)
35: ORDER BY pcv.NAME;

Line 8800: OKX_PARTY_CONTACTS_V OKX_PCONTACT

8796: CURSOR pcontact_csr IS
8797:
8798: select '1' from
8799:
8800: OKX_PARTY_CONTACTS_V OKX_PCONTACT
8801:
8802: WHERE ID1 = p_id1
8803:
8804: AND ID2 = p_id2;