APPS.ARH_DQM_TREE_HELPER dependencies on HZ_ORG_CONTACTS

Line 226: FROM hz_org_contacts

222: IS
223: CURSOR c_org_contact IS
224: SELECT org_contact_id,
225: party_site_id
226: FROM hz_org_contacts
227: WHERE party_relationship_id = p_rel_id;
228: ret NUMBER;
229: BEGIN
230: OPEN c_org_contact;

Line 494: FROM hz_org_contacts

490: x_msg_data OUT NOCOPY VARCHAR2)
491: IS
492: CURSOR c1 IS
493: SELECT NVL(party_site_id,-9999)
494: FROM hz_org_contacts
495: WHERE org_contact_id = p_contact_id;
496: l_ps_id NUMBER;
497: BEGIN
498: OPEN c1;