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 1455: from HZ_ORG_CONTACTS o, HZ_RELATIONSHIPS pr, HZ_parties p

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

Line 1558: 'CONTACTS','HZ_ORG_CONTACTS',

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' )
1562: LOOP

Line 1593: from hz_org_contacts a, hz_orig_sys_references b

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

Line 1595: and b.owner_table_name = 'HZ_ORG_CONTACTS'

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