APPS.HZ_DQM_SYNC dependencies on HZ_PARTY_SITES

Line 661: FROM HZ_PARTY_SITES ps, HZ_PARTIES p

657: END IF;
658: ELSIF (L_REALTIME_SYNC_VALUE = 'N') THEN
659: BEGIN
660: SELECT ps.party_id,p.party_type INTO l_party_id, l_party_type
661: FROM HZ_PARTY_SITES ps, HZ_PARTIES p
662: WHERE party_site_id = p_party_site_id
663: AND p.PARTY_ID = ps.PARTY_ID;
664: EXCEPTION
665: /* Bug No: 2707873. Added this exception because the above sql

Line 783: IF l_ot_table = 'HZ_PARTY_SITES' 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
785: INTO l_party_id1, l_party_site_id, l_party_type
786: FROM HZ_PARTY_SITES ps, HZ_PARTIES p
787: WHERE party_site_id = l_ot_id

Line 786: FROM HZ_PARTY_SITES ps, HZ_PARTIES p

782:
783: IF l_ot_table = 'HZ_PARTY_SITES' THEN
784: SELECT p.party_id, ps.party_site_id, party_type
785: INTO l_party_id1, l_party_site_id, l_party_type
786: FROM HZ_PARTY_SITES ps, HZ_PARTIES p
787: WHERE party_site_id = l_ot_id
788: AND p.party_id = ps.party_id;
789:
790: IF l_party_type = 'PARTY_RELATIONSHIP' THEN

Line 898: FROM hz_party_Sites

894: ) IS
895:
896: CURSOR party_sites IS
897: SELECT party_site_id
898: FROM hz_party_Sites
899: WHERE location_id = p_location_id
900: AND (status = 'A' or status = 'I') ;
901:
902: l_party_site_id NUMBER;

Line 1388: FROM HZ_PARTY_SITES

1384: END;
1385:
1386: IF p_from_fk_id = p_to_fk_id THEN
1387: SELECT party_id INTO l_party_id
1388: FROM HZ_PARTY_SITES
1389: WHERE party_site_id = p_from_id;
1390:
1391: l_party_site_id := p_from_id;
1392:

Line 1438: WHERE owner_table_name = 'HZ_PARTY_SITES'

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
1442: SELECT oc.org_contact_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 1486: IF l_ot_table = 'HZ_PARTY_SITES' THEN

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
1488: FROM HZ_PARTY_SITES
1489: WHERE party_site_id = l_ot_id;
1490:

Line 1488: FROM HZ_PARTY_SITES

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
1488: FROM HZ_PARTY_SITES
1489: WHERE party_site_id = l_ot_id;
1490:
1491: ELSIF l_ot_table = 'HZ_PARTIES' THEN
1492: SELECT party_type INTO l_party_type

Line 1590: FROM HZ_PARTY_SITES

1586: UPDATE HZ_STAGED_PARTY_SITES
1587: SET party_id = l_party_id
1588: WHERE party_site_id in (
1589: SELECT party_site_id
1590: FROM HZ_PARTY_SITES
1591: WHERE party_id = l_rel_party_id
1592: AND (nvl(STATUS,'A') = 'A' OR nvl(STATUS,'A')='I'));
1593:
1594: UPDATE HZ_STAGED_CONTACT_POINTS