APPS.HZ_PARTY_ACQUIRE dependencies on HZ_PARTY_SITES

Line 637: FROM HZ_PARTY_SITES ps, HZ_LOCATIONS l

633: ,ps.IDENTIFYING_ADDRESS_FLAG
634: ,ps.MAILSTOP
635: ,ps.PARTY_SITE_NAME
636: ,ps.PARTY_SITE_NUMBER
637: FROM HZ_PARTY_SITES ps, HZ_LOCATIONS l
638: WHERE ps.party_site_id = p_party_site_id
639: AND ps.location_id = l.location_id
640: AND (ps.status is null OR ps.status = 'A' or ps.status = 'I');
641:

Line 1419: FROM HZ_PARTY_SITES ps, HZ_LOCATIONS l

1415:
1416: CURSOR c_party_site IS
1417: SELECT rtrim(l.address1 || ' ' || l.address2 || ' ' ||
1418: l.address3 || ' ' || l.address4), rtrim(l.address1)
1419: FROM HZ_PARTY_SITES ps, HZ_LOCATIONS l
1420: WHERE ps.party_site_id = p_party_site_id
1421: AND ps.location_id = l.location_id;
1422:
1423: l_address VARCHAR2(4000);

Line 1557: 'PARTY_SITES', 'HZ_PARTY_SITES',

1553: from
1554: hz_orig_sys_references
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' )

Line 1583: from hz_party_sites a, hz_orig_sys_references b

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

Line 1585: and b.owner_table_name = 'HZ_PARTY_SITES'

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