APPS.OKL_UWQ_SEL_PKG dependencies on HZ_RELATIONSHIPS_V

Line 312: FROM hz_parties p, hz_relationships_v rel

308: -- private procedure to get the partyId
309: PROCEDURE GetDtlsFromConNum IS
310: CURSOR C_getDtlsFromConNum(x_contactNum VARCHAR2 ) IS
311: SELECT p.party_id, rel.object_id
312: FROM hz_parties p, hz_relationships_v rel
313: WHERE p.party_number = x_contactNum
314: AND p.party_id = rel.party_id;
315: BEGIN
316: OPEN C_getDtlsFromConNum (l_contactNumber);