APPS.HZ_IMP_MATCH_RULE_51 dependencies on HZ_SRCH_PSITES

Line 176: INSERT INTO HZ_SRCH_PSITES (

172: END LOOP;
173: SAVEPOINT pop_party_sites;
174: BEGIN
175: FORALL I in H_P_PARTY_OSR.FIRST..H_P_PARTY_OSR.LAST
176: INSERT INTO HZ_SRCH_PSITES (
177: TX11, TX14, TX22, TX9, PARTY_SITE_ID, PARTY_ID, PARTY_OS, PARTY_OSR, PARTY_SITE_OS, PARTY_SITE_OSR, NEW_PARTY_FLAG, BATCH_ID, INT_ROW_ID , TX26
178: ) VALUES (
179: H_TX11(I), H_TX14(I), H_TX22(I), H_TX9(I), H_P_PARTY_SITE_ID(I), H_P_PARTY_ID(I), H_P_PARTY_OS(I), H_P_PARTY_OSR(I), H_P_PS_OS(I), H_P_PS_OSR(I), H_P_N_PARTY(I), P_BATCH_ID, H_P_ROW_ID(I) , H_PS_CUST_TX26(I)
180: );

Line 398: INSERT INTO HZ_SRCH_PSITES (

394: END LOOP;
395: SAVEPOINT pop_party_sites_int;
396: BEGIN
397: FORALL I in H_P_PS_OSR.FIRST..H_P_PS_OSR.LAST
398: INSERT INTO HZ_SRCH_PSITES (
399: TX11, TX14, TX22, TX9, PARTY_OS, PARTY_OSR, PARTY_SITE_OS, PARTY_SITE_OSR, BATCH_ID, INT_ROW_ID, TX26 , PARTY_ID
400: ) VALUES (
401: H_TX11(I), H_TX14(I), H_TX22(I), H_TX9(I), H_P_PARTY_OS(I), H_P_PARTY_OSR(I), H_P_PS_OS(I), H_P_PS_OSR(I), P_BATCH_ID, H_P_ROW_ID(I), H_PS_CUST_TX26(I) , H_P_PARTY_ID(I)
402: );

Line 793: from hz_imp_dup_parties h1, HZ_SRCH_PSITES s1, HZ_STAGED_PARTY_SITES s2

789: decode(instrb(s2.TX22,s1.TX22),1,5,
790: 0
791: )
792: score
793: from hz_imp_dup_parties h1, HZ_SRCH_PSITES s1, HZ_STAGED_PARTY_SITES s2
794: where h1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
795: and s1.batch_id = h1.batch_id and s1.party_osr = h1.party_osr and s1.party_os = h1.party_os and s2.party_id = h1.dup_party_id
796: and (
797: ------------ NON FILTER ATTRIBUTES SECTION ------------------------

Line 936: from HZ_SRCH_PSITES s1, HZ_STAGED_PARTY_SITES s2

932: score , s1.party_osr, s1.party_os, p_batch_id,'PARTY_SITES', s1.PARTY_SITE_ID, s1.PARTY_SITE_OSR, s1.PARTY_SITE_OS,
933: s2.PARTY_SITE_ID
934: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
935: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
936: from HZ_SRCH_PSITES s1, HZ_STAGED_PARTY_SITES s2
937: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.new_party_flag = 'U'
938: and s1.party_id = s2.party_id
939: and (
940: ------------ NON FILTER ATTRIBUTES SECTION ------------------------

Line 1098: from hz_int_dup_results h1, HZ_SRCH_PSITES s1, HZ_SRCH_PSITES s2

1094: decode(instrb(s2.TX22,s1.TX22),1,5,
1095: 0
1096: )
1097: score
1098: from hz_int_dup_results h1, HZ_SRCH_PSITES s1, HZ_SRCH_PSITES s2
1099: where
1100: s1.party_osr = h1.f_osr and s2.party_osr = h1.t_osr and h1.batch_id = p_batch_id
1101: and s1.party_osr between from_osr and to_osr
1102: and (

Line 1196: from HZ_SRCH_PSITES s1, HZ_SRCH_PSITES s2

1192: )
1193: score ,hz_utility_v2pub.creation_date, hz_utility_v2pub.last_update_date
1194: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1195: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1196: from HZ_SRCH_PSITES s1, HZ_SRCH_PSITES s2
1197: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
1198: and ( ( (s1.party_osr = s2.party_osr) and ( nvl(s1.party_id, 1) = nvl(s2.party_id,1) ) ) OR ( s1.party_id = s2.party_id) )
1199: and s2.batch_id = p_batch_id and s1.PARTY_SITE_OSR < s2.PARTY_SITE_OSR
1200: and (