APPS.AP_VENDOR_PARTY_MERGE_PKG dependencies on HZ_CONTACT_POINTS

Line 987: HZ_CONTACT_POINTS hcpp

983: hcpp.owner_table_name contact_point_owner_name
984: from hz_parties hp,
985: hz_relationships hzr,
986: hz_party_usg_assignments hpua,
987: HZ_CONTACT_POINTS hcpp
988: where hp.party_id = hzr.subject_id
989: and hzr.subject_id = l_per_party_id /* bug 9604355 */
990: and hzr.relationship_type = 'CONTACT'
991: and hzr.relationship_code = 'CONTACT_OF'

Line 1223: FROM hz_contact_points

1219:
1220: BEGIN
1221: SELECT owner_table_id
1222: INTO l_contact_point_rec.owner_table_id
1223: FROM hz_contact_points
1224: WHERE owner_table_id = l_party_id
1225: AND owner_table_name = 'HZ_PARTIES'
1226: AND status = 'A'
1227: AND ROWNUM < 2;

Line 1295: FROM hz_contact_points

1291: l_telex_rec.telex_number,
1292: l_web_rec.web_type,
1293: l_web_rec.url,
1294: l_contact_point_rec.application_id
1295: FROM hz_contact_points
1296: WHERE contact_point_id = contact_point_loop_c.contact_point_id;
1297:
1298: l_contact_point_rec.owner_table_id := l_party_id;
1299: l_contact_point_rec.created_by_module := 'AP_SUPPLIERS_API';

Line 1480: FROM hz_contact_points

1476: IF p_create_partysite_cont_pts = 'Y'
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');

Line 1547: FROM hz_contact_points

1543: l_telex_rec.telex_number,
1544: l_web_rec.web_type,
1545: l_web_rec.url,
1546: l_contact_point_rec.application_id
1547: FROM hz_contact_points
1548: WHERE contact_point_id = contact_point_loop_c.contact_point_id;
1549:
1550: l_contact_point_rec.owner_table_id := p_to_party_site_id;
1551: l_contact_point_rec.created_by_module := 'AP_SUPPLIERS_API';