APPS.HZ_MATCH_RULE_51 dependencies on HZ_STAGED_CONTACTS

Line 2162: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID

2158: p_search_ctx_id NUMBER,
2159: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
2160: BEGIN
2161: OPEN x_cursor FOR
2162: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
2163: FROM HZ_STAGED_CONTACTS stage
2164: WHERE contains( concat_col, p_contains_str)>0
2165: AND ORG_CONTACT_ID in (
2166: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/

Line 2163: FROM HZ_STAGED_CONTACTS stage

2159: x_cursor OUT HZ_PARTY_STAGE.StageCurTyp) IS
2160: BEGIN
2161: OPEN x_cursor FOR
2162: SELECT /*+ INDEX(stage HZ_STAGED_CONTACTS_U1) */ ORG_CONTACT_ID, PARTY_ID
2163: FROM HZ_STAGED_CONTACTS stage
2164: WHERE contains( concat_col, p_contains_str)>0
2165: AND ORG_CONTACT_ID in (
2166: SELECT /*+ ORDERED INDEX(d hz_dqm_parties_gt_n1) USE_NL(d r)*/
2167: org_contact_id