DBA Data[Home] [Help]

APPS.ARH_DQM_PKG dependencies on HZ_RELATIONSHIPS

Line 1636: FROM hz_relationships a,

1632:
1633: CURSOR c_ct
1634: IS
1635: SELECT b.org_contact_id
1636: FROM hz_relationships a,
1637: hz_org_contacts b
1638: WHERE a.object_id = p_party_id
1639: AND a.directional_flag = 'F'
1640: AND a.relationship_id = b.party_relationship_id

Line 1663: hz_relationships b,

1659: UNION ALL
1660: SELECT a.contact_point_id,
1661: a.last_update_date
1662: FROM hz_contact_points a,
1663: hz_relationships b,
1664: hz_org_contacts c
1665: WHERE b.object_id = p_party_id
1666: AND b.directional_flag = 'F'
1667: AND b.party_id = a.owner_table_id