APPS.AP_VENDOR_PARTY_MERGE_PKG dependencies on HZ_PARTY_SITES

Line 1166: FROM hz_party_sites

1162: END IF;
1163:
1164: SELECT location_id
1165: INTO l_location_id
1166: FROM hz_party_sites
1167: WHERE party_site_id = contact_loop_c.party_site_id;
1168:
1169: l_party_site_rec.location_id := l_location_id;
1170: l_party_site_rec.created_by_module := 'AP_SUPPLIERS_API';

Line 1177: FROM hz_party_sites

1173:
1174: BEGIN
1175: SELECT party_site_id
1176: INTO l_party_site_id
1177: FROM hz_party_sites
1178: WHERE location_id = l_location_id
1179: AND party_id = l_party_id;
1180:
1181: EXCEPTION

Line 1481: WHERE owner_table_name = 'HZ_PARTY_SITES'

1477: THEN
1478: FOR contact_point_loop_c IN (
1479: SELECT contact_point_id
1480: FROM hz_contact_points
1481: WHERE owner_table_name = 'HZ_PARTY_SITES'
1482: AND owner_table_id = p_from_party_site_id
1483: ) LOOP
1484: FND_FILE.Put_Line(FND_FILE.Log,'inside party site contact points oop');
1485: BEGIN