APPS.HZ_PARTY_ACQUIRE dependencies on HZ_ORG_CONTACTS

Line 883: FROM HZ_ORG_CONTACTS o, HZ_RELATIONSHIPS pr, HZ_PERSON_PROFILES ps

879: ,ps.PERSON_TITLE
880: ,ps.PLACE_OF_BIRTH
881: ,ps.TAX_NAME
882: ,ps.TAX_REFERENCE
883: FROM HZ_ORG_CONTACTS o, HZ_RELATIONSHIPS pr, HZ_PERSON_PROFILES ps
884: WHERE o.party_relationship_id = pr.relationship_id
885: AND pr.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
886: AND pr.OBJECT_TABLE_NAME = 'HZ_PARTIES'
887: AND pr.DIRECTIONAL_FLAG = 'F'

Line 1454: from HZ_ORG_CONTACTS o, HZ_RELATIONSHIPS pr, HZ_parties p

1450: RETURN VARCHAR2 IS
1451:
1452: CURSOR cname IS
1453: select party_name
1454: from HZ_ORG_CONTACTS o, HZ_RELATIONSHIPS pr, HZ_parties p
1455: WHERE o.party_relationship_id = pr.relationship_id
1456: AND pr.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1457: AND pr.OBJECT_TABLE_NAME = 'HZ_PARTIES'
1458: AND pr.DIRECTIONAL_FLAG = 'F'

Line 1557: 'CONTACTS','HZ_ORG_CONTACTS',

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',
1558: 'CONTACT_POINTS', 'HZ_CONTACT_POINTS')
1559: and owner_table_id = p_record_id
1560: and nvl(STATUS,'A')='A' )
1561: LOOP

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 1594: and b.owner_table_name = 'HZ_ORG_CONTACTS'

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';
1597:
1598: END IF;