APPS.HZ_PARTY_ACQUIRE dependencies on HZ_ORIG_SYS_REFERENCES

Line 1553: hz_orig_sys_references

1549: THEN
1550: FOR t_cur in
1551: ( select orig_system, orig_system_reference
1552: from
1553: hz_orig_sys_references
1554: where owner_table_name = decode(p_entity,
1555: 'PARTY','HZ_PARTIES',
1556: 'PARTY_SITES', 'HZ_PARTY_SITES',
1557: 'CONTACTS','HZ_ORG_CONTACTS',

Line 1572: from hz_parties a, hz_orig_sys_references b

1568: IF p_entity = 'PARTY'
1569: THEN
1570: select b.orig_system || ' '||a.orig_system_reference
1571: into retstr
1572: from hz_parties a, hz_orig_sys_references b
1573: where b.owner_table_id = p_record_id
1574: and b.owner_table_name = 'HZ_PARTIES'
1575: and b.orig_system_reference = a.orig_system_reference
1576: and nvl(b.STATUS,'A')='A';

Line 1582: from hz_party_sites a, hz_orig_sys_references b

1578:
1579: IF p_entity = 'PARTY_SITES'
1580: THEN
1581: select b.orig_system || ' '||a.orig_system_reference into retstr
1582: from hz_party_sites a, hz_orig_sys_references b
1583: where b.owner_table_id = p_record_id
1584: and b.owner_table_name = 'HZ_PARTY_SITES'
1585: and b.orig_system_reference = a.orig_system_reference
1586: and nvl(b.STATUS,'A')='A';

Line 1592: from hz_org_contacts a, hz_orig_sys_references b

1588:
1589: IF p_entity = 'CONTACT'
1590: THEN
1591: select b.orig_system || ' '||a.orig_system_reference into retstr
1592: from hz_org_contacts a, hz_orig_sys_references b
1593: where b.owner_table_id = p_record_id
1594: and b.owner_table_name = 'HZ_ORG_CONTACTS'
1595: and b.orig_system_reference = a.orig_system_reference
1596: and nvl(b.STATUS,'A')='A';

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';