APPS.HZ_DQM_SYNC dependencies on HZ_CONTACT_POINTS

Line 791: FROM hz_contact_points

787: call_sync_index_serial ;
788: END IF;
789: ELSIF ( L_REALTIME_SYNC_VALUE = 'N') THEN
790: SELECT owner_table_name,owner_table_id INTO l_ot_table, l_ot_id
791: FROM hz_contact_points
792: WHERE contact_point_id = p_contact_point_id;
793:
794: IF l_ot_table = 'HZ_PARTY_SITES' THEN
795: SELECT p.party_id, ps.party_site_id, party_type

Line 1508: FROM HZ_CONTACT_POINTS

1504: l_party_type VARCHAR2(60);
1505:
1506: CURSOR c_cp_party_site (cp_id NUMBER) IS
1507: SELECT owner_table_id
1508: FROM HZ_CONTACT_POINTS
1509: WHERE owner_table_name = 'HZ_PARTY_SITES'
1510: AND contact_point_id = cp_id;
1511:
1512: CURSOR c_cp_org_contact (cp_id NUMBER) IS

Line 1514: FROM HZ_CONTACT_POINTS cp, HZ_RELATIONSHIPS rl, HZ_ORG_CONTACTS oc

1510: AND contact_point_id = cp_id;
1511:
1512: CURSOR c_cp_org_contact (cp_id NUMBER) IS
1513: SELECT oc.org_contact_id
1514: FROM HZ_CONTACT_POINTS cp, HZ_RELATIONSHIPS rl, HZ_ORG_CONTACTS oc
1515: WHERE owner_table_name = 'HZ_PARTIES'
1516: AND contact_point_id = cp_id
1517: AND rl.PARTY_ID = cp.owner_table_id
1518: AND oc.party_relationship_id = rl.relationship_id

Line 1567: FROM hz_contact_points

1563: l_contact_point_id := p_from_id;
1564: l_party_id := 0;
1565:
1566: SELECT owner_table_name,owner_table_id INTO l_ot_table, l_ot_id
1567: FROM hz_contact_points
1568: WHERE contact_point_id = l_contact_point_id;
1569:
1570: IF l_ot_table = 'HZ_PARTY_SITES' THEN
1571: SELECT party_id INTO l_party_id

Line 1689: FROM HZ_CONTACT_POINTS

1685: UPDATE HZ_STAGED_CONTACT_POINTS
1686: SET party_id = l_party_id
1687: WHERE contact_point_id in (
1688: SELECT contact_point_id
1689: FROM HZ_CONTACT_POINTS
1690: WHERE owner_table_name = 'HZ_PARTIES'
1691: AND owner_table_id = l_rel_party_id
1692: AND (nvl(STATUS,'A') = 'A' OR nvl(STATUS,'A')='I'));
1693:

Line 1711: FROM HZ_CONTACT_POINTS

1707: sync_party_site (I.party_site_id, 'U');
1708: END LOOP;
1709:
1710: FOR I IN (SELECT contact_point_id
1711: FROM HZ_CONTACT_POINTS
1712: WHERE owner_table_name = 'HZ_PARTIES'
1713: AND owner_table_id = l_rel_party_id
1714: AND (nvl(STATUS,'A') = 'A' OR nvl(STATUS,'A')='I'))
1715: LOOP