APPS.HZ_IMP_MATCH_RULE_50 dependencies on HZ_SRCH_PARTIES

Line 122: INSERT INTO HZ_SRCH_PARTIES (

118: END LOOP;
119: SAVEPOINT pop_parties;
120: BEGIN
121: FORALL I in H_P_PARTY_OSR.FIRST..H_P_PARTY_OSR.LAST
122: INSERT INTO HZ_SRCH_PARTIES (
123: TX2, TX36, TX41, TX45, TX59, PARTY_OS, PARTY_OSR, PARTY_ID, BATCH_ID, INT_ROW_ID
124: ) VALUES (
125: H_TX2(I), H_TX36(I), H_TX41(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)
126: );

Line 432: INSERT INTO HZ_SRCH_PARTIES (

428: END LOOP;
429: SAVEPOINT pop_parties_int;
430: BEGIN
431: FORALL I in H_P_PARTY_OSR.FIRST..H_P_PARTY_OSR.LAST
432: INSERT INTO HZ_SRCH_PARTIES (
433: TX2, TX36, TX41, TX45, TX59, PARTY_OS, PARTY_OSR, BATCH_ID, INT_ROW_ID , PARTY_ID
434: ) VALUES (
435: H_TX2(I), H_TX36(I), H_TX41(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)
436: );

Line 918: from HZ_SRCH_PARTIES s1, HZ_STAGED_PARTIES s2

914: decode(instrb(s2.TX45,s1.TX45),1,200,
915: 0
916: )
917: score , s1.party_osr party_osr, s1.party_os party_os
918: from HZ_SRCH_PARTIES s1, HZ_STAGED_PARTIES s2
919: where s1.party_id is not null and s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
920: and nvl(s2.status,'A') = 'A'
921: and (
922: -------PARTY ENTITY: ACQUISITION ON NON-FILTER ATTRIBUTES ---------

Line 979: SELECT 1 FROM HZ_SRCH_PARTIES p1, HZ_STAGED_PARTIES p2

975: group by f, t, party_osr, party_os
976: )
977: ------- ONE TIME CHECK FOR PARTY LEVEL FILTER ATTRIBUTES---------
978: where EXISTS (
979: SELECT 1 FROM HZ_SRCH_PARTIES p1, HZ_STAGED_PARTIES p2
980: WHERE p1.batch_id = p_batch_id and p1.party_osr = party_osr and p1.party_os = party_os
981: and p2.party_id = t
982: and
983: -- do an or between all the transformations of an attribute --

Line 1311: from HZ_SRCH_PARTIES s1, HZ_SRCH_PARTIES s2

1307: decode(instrb(s2.TX45,s1.TX45),1,200,
1308: 0
1309: )
1310: score, s1.party_os fos, s2.party_os tos
1311: from HZ_SRCH_PARTIES s1, HZ_SRCH_PARTIES s2
1312: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.party_osr <> s2.party_osr
1313: 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)
1314: and (
1315: -------PARTY ENTITY: ACQUISITION ON NON-FILTER ATTRIBUTES ---------

Line 1372: SELECT 1 FROM HZ_SRCH_PARTIES p1, HZ_SRCH_PARTIES p2

1368: group by f, t, fos, tos
1369: )
1370: ------- ONE TIME CHECK FOR PARTY LEVEL FILTER ATTRIBUTES---------
1371: where EXISTS (
1372: SELECT 1 FROM HZ_SRCH_PARTIES p1, HZ_SRCH_PARTIES p2
1373: WHERE p1.batch_id = p_batch_id and p1.party_osr = f and p1.party_os = fos
1374: and p2.batch_id = p_batch_id and p2.party_osr = t and p2.party_os = tos
1375: and
1376: -- do an or between all the transformations of an attribute --