APPS.HZ_MATCH_RULE_51 dependencies on HZ_STAGED_CONTACT_POINTS

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

1161: l_sqlstr VARCHAR2(4000);
1162: BEGIN
1163: IF p_party_id IS NOT NULL THEN
1164: OPEN x_cursor FOR
1165: 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.TX158, stage.TX10
1166: FROM HZ_STAGED_CONTACT_POINTS stage, HZ_SRCH_CPTS srch
1167: WHERE
1168: srch.batch_id = -1
1169: AND

Line 1166: FROM HZ_STAGED_CONTACT_POINTS stage, HZ_SRCH_CPTS srch

1162: BEGIN
1163: IF p_party_id IS NOT NULL THEN
1164: OPEN x_cursor FOR
1165: 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.TX158, stage.TX10
1166: FROM HZ_STAGED_CONTACT_POINTS stage, HZ_SRCH_CPTS srch
1167: WHERE
1168: srch.batch_id = -1
1169: AND
1170: (

Line 1191: FROM HZ_SRCH_CPTS srch, HZ_STAGED_CONTACT_POINTS stage

1187: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN
1188: IF p_search_ctx_id IS NULL THEN
1189: OPEN x_cursor FOR
1190: SELECT /*+ USE_NL(srch stage) */ stage.CONTACT_POINT_ID, stage.PARTY_ID, stage.PARTY_SITE_ID, stage.ORG_CONTACT_ID , stage.TX5, stage.TX158, stage.TX10
1191: FROM HZ_SRCH_CPTS srch, HZ_STAGED_CONTACT_POINTS stage
1192: WHERE
1193: srch.batch_id = -1
1194: AND
1195: (

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

1210: AND ((g_party_stage_rec.TX36 IS NULL OR g_party_stage_rec.TX36||' ' = p.TX36)))
1211: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1212: ELSE
1213: OPEN x_cursor FOR
1214: 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.TX158, stage.TX10
1215: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage, HZ_SRCH_CPTS srch
1216: WHERE
1217: srch.batch_id = -1
1218: AND

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

1211: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1212: ELSE
1213: OPEN x_cursor FOR
1214: 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.TX158, stage.TX10
1215: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_CONTACT_POINTS stage, HZ_SRCH_CPTS srch
1216: WHERE
1217: srch.batch_id = -1
1218: AND
1219: (

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

1233: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1234: END IF;
1235: ELSE
1236: 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.TX158, stage.TX10'||
1237: ' FROM HZ_SRCH_CPTS srch, HZ_STAGED_CONTACT_POINTS stage'||
1238: ' WHERE'||
1239: 'srch.batch_id = -1'||
1240: 'AND'||
1241: '('||