APPS.HZ_MATCH_RULE_58 dependencies on HZ_PARTY_SITES

Line 4267: where owner_table_name = 'HZ_PARTY_SITES'

4263: p_contact_ids HZ_PARTY_SEARCH.IDList;
4264: l_match_idx NUMBER;
4265: cursor get_cpts_for_party_sites is select contact_point_id
4266: from hz_contact_points
4267: where owner_table_name = 'HZ_PARTY_SITES'
4268: and primary_flag='Y'
4269: and owner_table_id = p_party_site_id;
4270: BEGIN
4271: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 5689: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES

5685: AND ROWNUM<6
5686: UNION
5687:
5688: SELECT CONTACT_POINT_ID
5689: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
5690: WHERE PRIMARY_FLAG = 'Y'
5691: AND owner_table_name = 'HZ_PARTY_SITES'
5692: AND owner_table_id = party_site_id
5693: AND PARTY_ID = p_party_id

Line 5691: AND owner_table_name = 'HZ_PARTY_SITES'

5687:
5688: SELECT CONTACT_POINT_ID
5689: FROM HZ_CONTACT_POINTS,HZ_PARTY_SITES
5690: WHERE PRIMARY_FLAG = 'Y'
5691: AND owner_table_name = 'HZ_PARTY_SITES'
5692: AND owner_table_id = party_site_id
5693: AND PARTY_ID = p_party_id
5694: AND IDENTIFYING_ADDRESS_FLAG = 'Y') LOOP
5695: l_contact_pt_ids(cpt) := CONTACT_POINTS.CONTACT_POINT_ID;

Line 5835: FROM HZ_PARTY_SITES, HZ_LOCATIONS

5831: x_party_site_list OUT NOCOPY HZ_PARTY_SEARCH.party_site_list
5832: ) IS
5833: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5834: SELECT party_site_id
5835: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5836: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5837: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5838:
5839: I NUMBER;

Line 5836: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id

5832: ) IS
5833: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5834: SELECT party_site_id
5835: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5836: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5837: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5838:
5839: I NUMBER;
5840: J NUMBER:=1;

Line 5837: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;

5833: CURSOR c_party_sites(cp_party_site_id NUMBER) IS
5834: SELECT party_site_id
5835: FROM HZ_PARTY_SITES, HZ_LOCATIONS
5836: WHERE HZ_PARTY_SITES.party_site_id = cp_party_site_id
5837: AND HZ_PARTY_SITES.location_id = HZ_LOCATIONS.location_id;
5838:
5839: I NUMBER;
5840: J NUMBER:=1;
5841: l_party_site_id NUMBER;