APPS.HZ_MATCH_RULE_50 dependencies on HZ_STAGED_PARTY_SITES

Line 1238: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, stage.TX26, stage.TX9, stage.TX14, stage.TX22

1234: l_sqlstr VARCHAR2(4000);
1235: BEGIN
1236: IF p_party_id IS NOT NULL THEN
1237: OPEN x_cursor FOR
1238: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, stage.TX26, stage.TX9, stage.TX14, stage.TX22
1239: FROM HZ_STAGED_PARTY_SITES stage,HZ_SRCH_PSITES srch
1240: WHERE
1241: srch.batch_id = -1
1242: AND

Line 1239: FROM HZ_STAGED_PARTY_SITES stage,HZ_SRCH_PSITES srch

1235: BEGIN
1236: IF p_party_id IS NOT NULL THEN
1237: OPEN x_cursor FOR
1238: SELECT /*+ INDEX(stage HZ_STAGED_PARTY_SITES_N1) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, stage.TX26, stage.TX9, stage.TX14, stage.TX22
1239: FROM HZ_STAGED_PARTY_SITES stage,HZ_SRCH_PSITES srch
1240: WHERE
1241: srch.batch_id = -1
1242: AND
1243: (

Line 1259: FROM HZ_SRCH_PSITES srch, HZ_STAGED_PARTY_SITES stage, HZ_STAGED_PARTIES p

1255: ELSIF p_restrict_sql IS NULL OR p_search_ctx_id IS NOT NULL THEN
1256: IF p_search_ctx_id IS NULL THEN
1257: OPEN x_cursor FOR
1258: SELECT /*+ ORDERED USE_NL(srch stage p) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, stage.TX26, stage.TX9, stage.TX14, stage.TX22
1259: FROM HZ_SRCH_PSITES srch, HZ_STAGED_PARTY_SITES stage, HZ_STAGED_PARTIES p
1260: WHERE
1261: srch.batch_id = -1
1262: AND
1263: (

Line 1276: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage, HZ_SRCH_PSITES srch

1272: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1273: ELSE
1274: OPEN x_cursor FOR
1275: SELECT stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID, stage.TX26, stage.TX9, stage.TX14, stage.TX22
1276: FROM HZ_DQM_PARTIES_GT d, HZ_STAGED_PARTY_SITES stage, HZ_SRCH_PSITES srch
1277: WHERE
1278: srch.batch_id = -1
1279: AND
1280: (

Line 1293: ' FROM HZ_SRCH_PSITES srch, HZ_STAGED_PARTY_SITES stage, HZ_STAGED_PARTIES p'||

1289: AND (p_dup_party_id IS NULL OR stage.party_id <> p_dup_party_id);
1290: END IF;
1291: ELSE
1292: l_sqlstr := 'SELECT /*+ ORDERED USE_NL(srch stage p) */ stage.PARTY_SITE_ID, stage.PARTY_ID, stage.ORG_CONTACT_ID , stage.TX26, stage.TX9, stage.TX14, stage.TX22'||
1293: ' FROM HZ_SRCH_PSITES srch, HZ_STAGED_PARTY_SITES stage, HZ_STAGED_PARTIES p'||
1294: ' WHERE' ||
1295: 'srch.batch_id = -1'||
1296: 'AND'||
1297: '('||