APPS.HZ_IMP_MATCH_RULE_52 dependencies on HZ_SRCH_PSITES

Line 190: INSERT INTO HZ_SRCH_PSITES (

186: END LOOP;
187: SAVEPOINT pop_party_sites;
188: BEGIN
189: FORALL I in H_P_PARTY_OSR.FIRST..H_P_PARTY_OSR.LAST
190: INSERT INTO HZ_SRCH_PSITES (
191: 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
192: ) VALUES (
193: 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)
194: );

Line 496: INSERT INTO HZ_SRCH_PSITES (

492: END LOOP;
493: SAVEPOINT pop_party_sites_int;
494: BEGIN
495: FORALL I in H_P_PS_OSR.FIRST..H_P_PS_OSR.LAST
496: INSERT INTO HZ_SRCH_PSITES (
497: TX11, TX14, TX22, TX9, PARTY_OS, PARTY_OSR, PARTY_SITE_OS, PARTY_SITE_OSR, BATCH_ID, INT_ROW_ID, TX26 , PARTY_ID
498: ) VALUES (
499: 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)
500: );

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

1025: decode(instrb(s2.TX22,s1.TX22),1,5,
1026: 0
1027: )
1028: score
1029: from hz_imp_dup_parties h1, HZ_SRCH_PSITES s1, HZ_STAGED_PARTY_SITES s2
1030: where h1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
1031: 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
1032: and (
1033: ------------ NON FILTER ATTRIBUTES SECTION ------------------------

Line 1215: from HZ_SRCH_PSITES s1, HZ_STAGED_PARTY_SITES s2

1211: score , s1.party_osr, s1.party_os, p_batch_id,'PARTY_SITES', s1.PARTY_SITE_ID, s1.PARTY_SITE_OSR, s1.PARTY_SITE_OS,
1212: s2.PARTY_SITE_ID
1213: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1214: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1215: from HZ_SRCH_PSITES s1, HZ_STAGED_PARTY_SITES s2
1216: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr and s1.new_party_flag = 'U'
1217: and s1.party_id = s2.party_id
1218: and (
1219: ------------ NON FILTER ATTRIBUTES SECTION ------------------------

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

1438: decode(instrb(s2.TX22,s1.TX22),1,5,
1439: 0
1440: )
1441: score
1442: from hz_int_dup_results h1, HZ_SRCH_PSITES s1, HZ_SRCH_PSITES s2
1443: where
1444: s1.party_osr = h1.f_osr and s2.party_osr = h1.t_osr and h1.batch_id = p_batch_id
1445: and s1.party_osr between from_osr and to_osr
1446: and (

Line 1585: from HZ_SRCH_PSITES s1, HZ_SRCH_PSITES s2

1581: )
1582: score ,hz_utility_v2pub.creation_date, hz_utility_v2pub.last_update_date
1583: ,hz_utility_v2pub.created_by,hz_utility_v2pub.creation_date,hz_utility_v2pub.last_update_login
1584: ,hz_utility_v2pub.last_update_date,hz_utility_v2pub.last_updated_by
1585: from HZ_SRCH_PSITES s1, HZ_SRCH_PSITES s2
1586: where s1.batch_id = p_batch_id and s1.party_osr between from_osr and to_osr
1587: 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) )
1588: and s2.batch_id = p_batch_id and s1.PARTY_SITE_OSR < s2.PARTY_SITE_OSR
1589: and (