APPS.MSC_SRP_RELEASE dependencies on HZ_RELATIONSHIPS

Line 859: Hz_Relationships r,

855: BEGIN
856: SELECT r.party_id
857: INTO l_customer_contact_id
858: FROM Hz_Parties sub,
859: Hz_Relationships r,
860: Hz_Parties obj
861: WHERE r.object_id = l_party_id
862: --AND r.party_id = p_customer_contact_id
863: AND sub.status = 'A'