APPS.HZ_MATCH_RULE_52 dependencies on HZ_STAGED_CONTACT_POINTS

Line 1482: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ stage.CONTACT_POINT_ID, stage.PARTY_ID,stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , stage.TX5, stage.TX7, stage.TX10, stage.TX158

1478: l_sqlstr VARCHAR2(4000);
1479: BEGIN
1480: IF p_party_id IS NOT NULL THEN
1481: OPEN x_cursor FOR
1482: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ stage.CONTACT_POINT_ID, stage.PARTY_ID,stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , stage.TX5, stage.TX7, stage.TX10, stage.TX158
1483: FROM HZ_STAGED_CONTACT_POINTS stage, HZ_SRCH_CPTS srch
1484: WHERE
1485: srch.batch_id = -1
1486: AND

Line 1483: FROM HZ_STAGED_CONTACT_POINTS stage, HZ_SRCH_CPTS srch

1479: BEGIN
1480: IF p_party_id IS NOT NULL THEN
1481: OPEN x_cursor FOR
1482: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ stage.CONTACT_POINT_ID, stage.PARTY_ID,stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , stage.TX5, stage.TX7, stage.TX10, stage.TX158
1483: FROM HZ_STAGED_CONTACT_POINTS stage, HZ_SRCH_CPTS srch
1484: WHERE
1485: srch.batch_id = -1
1486: AND
1487: (

Line 1513: FROM HZ_SRCH_CPTS srch, HZ_STAGED_CONTACT_POINTS stage

1509: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN
1510: IF p_search_ctx_id IS NULL THEN
1511: OPEN x_cursor FOR
1512: SELECT /*+ USE_NL(srch stage) */ stage.CONTACT_POINT_ID, stage.PARTY_ID, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , stage.TX5, stage.TX7, stage.TX10, stage.TX158
1513: FROM HZ_SRCH_CPTS srch, HZ_STAGED_CONTACT_POINTS stage
1514: WHERE
1515: srch.batch_id = -1
1516: AND
1517: (

Line 1541: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ stage.CONTACT_POINT_ID, stage.PARTY_ID, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , stage.TX5, stage.TX7, stage.TX10, stage.TX158

1537: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = p.TX36) AND (g_party_stage_rec.TX46 IS NULL OR g_party_stage_rec.TX46||' ' = p.TX46)))
1538: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1539: ELSE
1540: OPEN x_cursor FOR
1541: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ stage.CONTACT_POINT_ID, stage.PARTY_ID, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , stage.TX5, stage.TX7, stage.TX10, stage.TX158
1542: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage, HZ_SRCH_CPTS srch
1543: WHERE
1544: srch.batch_id = -1
1545: AND

Line 1542: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage, HZ_SRCH_CPTS srch

1538: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1539: ELSE
1540: OPEN x_cursor FOR
1541: SELECT /*+ ORDERED INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ stage.CONTACT_POINT_ID, stage.PARTY_ID, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , stage.TX5, stage.TX7, stage.TX10, stage.TX158
1542: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage, HZ_SRCH_CPTS srch
1543: WHERE
1544: srch.batch_id = -1
1545: AND
1546: (

Line 1569: ' FROM HZ_SRCH_CPTS srch, HZ_STAGED_CONTACT_POINTS stage'||

1565: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1566: END IF;
1567: ELSE
1568: l_sqlstr := 'SELECT /*+ USE_NL(srch stage) */ stage.CONTACT_POINT_ID, stage.PARTY_ID, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , stage.TX5, stage.TX7, stage.TX10, stage.TX158'||
1569: ' FROM HZ_SRCH_CPTS srch, HZ_STAGED_CONTACT_POINTS stage'||
1570: ' WHERE'||
1571: 'srch.batch_id = -1'||
1572: 'AND'||
1573: '('||