APPS.HZ_MATCH_RULE_50 dependencies on HZ_STAGED_CONTACT_POINTS

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

1432: l_sqlstr VARCHAR2(4000);
1433: BEGIN
1434: IF p_party_id IS NOT NULL THEN
1435: OPEN x_cursor FOR
1436: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ stage.CONTACT_POINT_ID, stage.PARTY_ID,stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , stage.TX7, stage.TX158, stage.TX10
1437: FROM HZ_STAGED_CONTACT_POINTS stage, HZ_SRCH_CPTS srch
1438: WHERE
1439: srch.batch_id = -1
1440: AND

Line 1437: FROM HZ_STAGED_CONTACT_POINTS stage, HZ_SRCH_CPTS srch

1433: BEGIN
1434: IF p_party_id IS NOT NULL THEN
1435: OPEN x_cursor FOR
1436: SELECT /*+ INDEX(stage HZ_STAGED_CONTACT_POINTS_N1) */ stage.CONTACT_POINT_ID, stage.PARTY_ID,stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , stage.TX7, stage.TX158, stage.TX10
1437: FROM HZ_STAGED_CONTACT_POINTS stage, HZ_SRCH_CPTS srch
1438: WHERE
1439: srch.batch_id = -1
1440: AND
1441: (

Line 1462: FROM HZ_SRCH_CPTS srch, HZ_STAGED_CONTACT_POINTS stage

1458: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN
1459: IF p_search_ctx_id IS NULL THEN
1460: OPEN x_cursor FOR
1461: SELECT /*+ USE_NL(srch stage) */ stage.CONTACT_POINT_ID, stage.PARTY_ID, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , stage.TX7, stage.TX158, stage.TX10
1462: FROM HZ_SRCH_CPTS srch, HZ_STAGED_CONTACT_POINTS stage
1463: WHERE
1464: srch.batch_id = -1
1465: AND
1466: (

Line 1485: 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.TX7, stage.TX158, stage.TX10

1481: 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)))
1482: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1483: ELSE
1484: OPEN x_cursor FOR
1485: 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.TX7, stage.TX158, stage.TX10
1486: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage, HZ_SRCH_CPTS srch
1487: WHERE
1488: srch.batch_id = -1
1489: AND

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

1482: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1483: ELSE
1484: OPEN x_cursor FOR
1485: 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.TX7, stage.TX158, stage.TX10
1486: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage, HZ_SRCH_CPTS srch
1487: WHERE
1488: srch.batch_id = -1
1489: AND
1490: (

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

1504: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1505: END IF;
1506: ELSE
1507: l_sqlstr := 'SELECT /*+ USE_NL(srch stage) */ stage.CONTACT_POINT_ID, stage.PARTY_ID, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , stage.TX7, stage.TX158, stage.TX10'||
1508: ' FROM HZ_SRCH_CPTS srch, HZ_STAGED_CONTACT_POINTS stage'||
1509: ' WHERE'||
1510: 'srch.batch_id = -1'||
1511: 'AND'||
1512: '('||