APPS.HZ_PARTY_ACQUIRE dependencies on HZ_CONTACT_POINTS

Line 1126: FROM HZ_CONTACT_POINTS

1122: ,TELEX_NUMBER
1123: ,TIME_ZONE
1124: ,URL
1125: ,WEB_TYPE
1126: FROM HZ_CONTACT_POINTS
1127: WHERE contact_point_id = p_contact_point_id
1128: AND (status is null OR status = 'A' or status = 'I');
1129:
1130: CURSOR custom_attribs IS

Line 1491: FROM HZ_CONTACT_POINTS

1487: RETURN VARCHAR2 IS
1488:
1489: CURSOR cpt IS
1490: SELECT PHONE_NUMBER, PHONE_AREA_CODE, PHONE_COUNTRY_CODE
1491: FROM HZ_CONTACT_POINTS
1492: WHERE contact_point_id = p_contact_pt_id;
1493:
1494: l_phone_number VARCHAR2(255);
1495: l_phone_area_code VARCHAR2(255);

Line 1559: 'CONTACT_POINTS', 'HZ_CONTACT_POINTS')

1555: where owner_table_name = decode(p_entity,
1556: 'PARTY','HZ_PARTIES',
1557: 'PARTY_SITES', 'HZ_PARTY_SITES',
1558: 'CONTACTS','HZ_ORG_CONTACTS',
1559: 'CONTACT_POINTS', 'HZ_CONTACT_POINTS')
1560: and owner_table_id = p_record_id
1561: and nvl(STATUS,'A')='A' )
1562: LOOP
1563: retstr := retstr || t_cur.orig_system ||' '|| t_cur.orig_system_reference || ' ';

Line 1604: from hz_contact_points a, hz_orig_sys_references b

1600:
1601: IF p_entity = 'CONTACT_POINTS'
1602: THEN
1603: select b.orig_system || ' '||a.orig_system_reference into retstr
1604: from hz_contact_points a, hz_orig_sys_references b
1605: where b.owner_table_id = p_record_id
1606: and b.owner_table_name = 'HZ_CONTACT_POINTS'
1607: and b.orig_system_reference = a.orig_system_reference
1608: and nvl(b.STATUS,'A')='A';

Line 1606: and b.owner_table_name = 'HZ_CONTACT_POINTS'

1602: THEN
1603: select b.orig_system || ' '||a.orig_system_reference into retstr
1604: from hz_contact_points a, hz_orig_sys_references b
1605: where b.owner_table_id = p_record_id
1606: and b.owner_table_name = 'HZ_CONTACT_POINTS'
1607: and b.orig_system_reference = a.orig_system_reference
1608: and nvl(b.STATUS,'A')='A';
1609:
1610: END IF;