APPS.HZ_IMP_MATCH_RULE_51 dependencies on HZ_SRCH_PARTIES

Line 109: INSERT INTO HZ_SRCH_PARTIES (

105: END LOOP;
106: SAVEPOINT pop_parties;
107: BEGIN
108: FORALL I in H_P_PARTY_OSR.FIRST..H_P_PARTY_OSR.LAST
109: INSERT INTO HZ_SRCH_PARTIES (
110: TX2, TX36, TX45, TX59, PARTY_OS, PARTY_OSR, PARTY_ID, BATCH_ID, INT_ROW_ID
111: ) VALUES (
112: H_TX2(I), H_TX36(I), H_TX45(I), H_TX59(I), H_P_PARTY_OS(I), H_P_PARTY_OSR(I), H_P_PARTY_ID(I), P_BATCH_ID, H_P_ROW_ID(I)
113: );

Line 335: INSERT INTO HZ_SRCH_PARTIES (

331: END LOOP;
332: SAVEPOINT pop_parties_int;
333: BEGIN
334: FORALL I in H_P_PARTY_OSR.FIRST..H_P_PARTY_OSR.LAST
335: INSERT INTO HZ_SRCH_PARTIES (
336: TX2, TX36, TX45, TX59, PARTY_OS, PARTY_OSR, BATCH_ID, INT_ROW_ID , PARTY_ID
337: ) VALUES (
338: H_TX2(I), H_TX36(I), H_TX45(I), H_TX59(I), H_P_PARTY_OS(I), H_P_PARTY_OSR(I), P_BATCH_ID, H_P_ROW_ID(I) , H_P_PARTY_ID(I)
339: );

Line 706: from HZ_SRCH_PARTIES s1, HZ_STAGED_PARTIES s2

702: decode(instrb(s2.TX45,s1.TX45),1,200,
703: 0
704: )
705: score , s1.party_osr party_osr, s1.party_os party_os
706: from HZ_SRCH_PARTIES s1, HZ_STAGED_PARTIES s2
707: where s1.party_id is not null and s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
708: and nvl(s2.status,'A') = 'A'
709: and (
710: -------PARTY ENTITY: ACQUISITION ON NON-FILTER ATTRIBUTES ---------

Line 755: SELECT 1 FROM HZ_SRCH_PARTIES p1, HZ_STAGED_PARTIES p2

751: group by f, t, party_osr, party_os
752: )
753: ------- ONE TIME CHECK FOR PARTY LEVEL FILTER ATTRIBUTES---------
754: where EXISTS (
755: SELECT 1 FROM HZ_SRCH_PARTIES p1, HZ_STAGED_PARTIES p2
756: WHERE p1.batch_id = p_batch_id and p1.party_osr = party_osr and p1.party_os = party_os
757: and p2.party_id = t
758: and
759: -- do an or between all the transformations of an attribute --

Line 1009: from HZ_SRCH_PARTIES s1, HZ_SRCH_PARTIES s2

1005: decode(instrb(s2.TX45,s1.TX45),1,200,
1006: 0
1007: )
1008: score, s1.party_os fos, s2.party_os tos
1009: from HZ_SRCH_PARTIES s1, HZ_SRCH_PARTIES s2
1010: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.party_osr <> s2.party_osr
1011: and s2.batch_id = p_batch_id and not exists (select 1 from HZ_INT_DUP_RESULTS WHERE t_osr = s1.party_osr and batch_id = p_batch_id)
1012: and (
1013: -------PARTY ENTITY: ACQUISITION ON NON-FILTER ATTRIBUTES ---------

Line 1059: SELECT 1 FROM HZ_SRCH_PARTIES p1, HZ_SRCH_PARTIES p2

1055: group by f, t, fos, tos
1056: )
1057: ------- ONE TIME CHECK FOR PARTY LEVEL FILTER ATTRIBUTES---------
1058: where EXISTS (
1059: SELECT 1 FROM HZ_SRCH_PARTIES p1, HZ_SRCH_PARTIES p2
1060: WHERE p1.batch_id = p_batch_id and p1.party_osr = f and p1.party_os = fos
1061: and p2.batch_id = p_batch_id and p2.party_osr = t and p2.party_os = tos
1062: and
1063: -- do an or between all the transformations of an attribute --