DBA Data[Home] [Help]

APPS.MSC_SRP_RELEASE dependencies on HZ_RELATIONSHIPS

Line 857: Hz_Relationships r,

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