APPS.OKL_UWQ_SEL_PKG dependencies on HZ_PARTIES

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);

Line 323: FROM hz_parties

319: END GetDtlsFromConNum;
320: PROCEDURE GetDtlsFromCustNum IS
321: CURSOR C_GetCustId(x_custnum VARCHAR2) IS
322: SELECT party_id
323: FROM hz_parties
324: WHERE party_number = x_custnum;
325: BEGIN
326: OPEN c_getcustid(l_customernumber);
327: FETCH c_getcustid INTO l_partyId;