APPS.HZ_DQM_SYNC dependencies on HZ_ORG_CONTACTS

Line 592: FROM HZ_RELATIONSHIPS pr, HZ_ORG_CONTACTS oc

588: l_sql_err_message VARCHAR2(2000);
589:
590: CURSOR c_contact IS
591: SELECT oc.org_contact_id
592: FROM HZ_RELATIONSHIPS pr, HZ_ORG_CONTACTS oc
593: WHERE pr.relationship_id = oc.party_relationship_id
594: AND pr.subject_id = p_party_id
595: AND pr.subject_table_name = 'HZ_PARTIES'
596: AND pr.object_table_name = 'HZ_PARTIES'

Line 673: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r

669: END;
670: IF l_party_type = 'PARTY_RELATIONSHIP' THEN
671: BEGIN
672: SELECT r.object_id, org_contact_id INTO l_party_id1,l_org_contact_id
673: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
674: WHERE r.party_id = l_party_id
675: AND r.relationship_id = oc.party_relationship_id
676: AND r.directional_flag='F'
677: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 723: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r

719: call_sync_index_serial ;
720: END IF;
721: ELSIF ( L_REALTIME_SYNC_VALUE = 'N') THEN
722: SELECT r.object_id INTO l_party_id
723: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
724: WHERE oc.org_contact_id = p_org_contact_id
725: AND oc.party_relationship_id = r.relationship_id
726: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
727: AND r.OBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 793: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r

789:
790: IF l_party_type = 'PARTY_RELATIONSHIP' THEN
791: BEGIN
792: SELECT r.object_id, org_contact_id INTO l_party_id,l_org_contact_id
793: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
794: WHERE r.party_id = l_party_id1
795: AND r.relationship_id = oc.party_relationship_id
796: AND r.directional_flag='F'
797: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 819: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r

815: l_org_contact_id:=NULL;
816: ELSE
817: BEGIN
818: SELECT r.object_id, org_contact_id INTO l_party_id,l_org_contact_id
819: FROM HZ_ORG_CONTACTS oc, HZ_RELATIONSHIPS r
820: WHERE r.party_id = l_ot_id
821: AND r.relationship_id = oc.party_relationship_id
822: AND r.directional_flag='F'
823: AND r.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 857: FROM hz_org_contacts

853: ) IS
854:
855: CURSOR org_contacts IS
856: SELECT org_contact_id
857: FROM hz_org_contacts
858: WHERE party_relationship_id = p_relationship_id
859: AND status = 'A';
860:
861: l_org_contact_id NUMBER;

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 1454: FROM HZ_PARTY_SITES ps, HZ_RELATIONSHIPS rl, HZ_ORG_CONTACTS oc

1450: AND rl.DIRECTIONAL_FLAG = 'F';
1451:
1452: CURSOR c_ps_org_contact (ps_id NUMBER) IS
1453: SELECT oc.org_contact_id
1454: FROM HZ_PARTY_SITES ps, HZ_RELATIONSHIPS rl, HZ_ORG_CONTACTS oc
1455: WHERE ps.party_site_id = ps_id
1456: AND rl.PARTY_ID = ps.party_id
1457: AND oc.party_relationship_id = rl.relationship_id
1458: AND rl.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 1507: FROM HZ_ORG_CONTACTS

1503: AND object_table_name = 'HZ_PARTIES'
1504: AND directional_flag = 'F';
1505:
1506: SELECT count(1) INTO l_num_ocs
1507: FROM HZ_ORG_CONTACTS
1508: WHERE party_relationship_id = l_pr_id;
1509:
1510: IF l_num_ocs = 0 THEN
1511: l_party_id := 0;

Line 1575: FROM HZ_RELATIONSHIPS pr, HZ_ORG_CONTACTS oc --bug 4500011 replaced hz_party_relationships with hz_relationships

1571: IF p_from_fk_id = p_to_fk_id THEN
1572: l_org_contact_id := p_from_id;
1573:
1574: SELECT pr.party_id, pr.object_id INTO l_rel_party_id, l_party_id
1575: FROM HZ_RELATIONSHIPS pr, HZ_ORG_CONTACTS oc --bug 4500011 replaced hz_party_relationships with hz_relationships
1576: WHERE oc.org_contact_id = l_org_contact_id
1577: AND pr.relationship_id = oc.party_relationship_id
1578: AND pr.subject_table_name = 'HZ_PARTIES'
1579: AND pr.object_table_name = 'HZ_PARTIES'