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 1490: FROM HZ_CONTACT_POINTS

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

Line 1558: 'CONTACT_POINTS', 'HZ_CONTACT_POINTS')

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

Line 1603: from hz_contact_points a, hz_orig_sys_references b

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

Line 1605: and b.owner_table_name = 'HZ_CONTACT_POINTS'

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