APPS.HZ_DQM_SYNC dependencies on HZ_CONTACT_POINTS

Line 780: FROM hz_contact_points

776: call_sync_index_serial ;
777: END IF;
778: ELSIF ( L_REALTIME_SYNC_VALUE = 'N') THEN
779: SELECT owner_table_name,owner_table_id INTO l_ot_table, l_ot_id
780: FROM hz_contact_points
781: WHERE contact_point_id = p_contact_point_id;
782:
783: IF l_ot_table = 'HZ_PARTY_SITES' THEN
784: SELECT p.party_id, ps.party_site_id, party_type

Line 1437: FROM HZ_CONTACT_POINTS

1433: l_party_type VARCHAR2(60);
1434:
1435: CURSOR c_cp_party_site (cp_id NUMBER) IS
1436: SELECT owner_table_id
1437: FROM HZ_CONTACT_POINTS
1438: WHERE owner_table_name = 'HZ_PARTY_SITES'
1439: AND contact_point_id = cp_id;
1440:
1441: CURSOR c_cp_org_contact (cp_id NUMBER) IS

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

1439: AND contact_point_id = cp_id;
1440:
1441: CURSOR c_cp_org_contact (cp_id NUMBER) IS
1442: SELECT oc.org_contact_id
1443: FROM HZ_CONTACT_POINTS cp, HZ_RELATIONSHIPS rl, HZ_ORG_CONTACTS oc
1444: WHERE owner_table_name = 'HZ_PARTIES'
1445: AND contact_point_id = cp_id
1446: AND rl.PARTY_ID = cp.owner_table_id
1447: AND oc.party_relationship_id = rl.relationship_id

Line 1483: FROM hz_contact_points

1479: l_contact_point_id := p_from_id;
1480: l_party_id := 0;
1481:
1482: SELECT owner_table_name,owner_table_id INTO l_ot_table, l_ot_id
1483: FROM hz_contact_points
1484: WHERE contact_point_id = l_contact_point_id;
1485:
1486: IF l_ot_table = 'HZ_PARTY_SITES' THEN
1487: SELECT party_id INTO l_party_id

Line 1598: FROM HZ_CONTACT_POINTS

1594: UPDATE HZ_STAGED_CONTACT_POINTS
1595: SET party_id = l_party_id
1596: WHERE contact_point_id in (
1597: SELECT contact_point_id
1598: FROM HZ_CONTACT_POINTS
1599: WHERE owner_table_name = 'HZ_PARTIES'
1600: AND owner_table_id = l_rel_party_id
1601: AND (nvl(STATUS,'A') = 'A' OR nvl(STATUS,'A')='I'));
1602: