1644: CURSOR c_cpt
1645: IS
1646: SELECT a.contact_point_id,
1647: a.last_update_date
1648: FROM hz_contact_points a
1649: WHERE a.owner_table_name = 'HZ_PARTIES'
1650: AND a.owner_table_id = p_party_id
1651: UNION ALL
1652: SELECT a.contact_point_id,
1650: AND a.owner_table_id = p_party_id
1651: UNION ALL
1652: SELECT a.contact_point_id,
1653: a.last_update_date
1654: FROM hz_contact_points a,
1655: hz_party_sites b
1656: WHERE a.owner_table_name = 'HZ_PARTY_SITES'
1657: AND a.owner_table_id = b.party_site_id
1658: AND b.party_id = p_party_id
1658: AND b.party_id = p_party_id
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'