APPS.HZ_PURGE_GEN dependencies on WSH_PARTY_SITES_V

Line 2934: --WSH_PARTY_SITES_V;PARTY_SITE_ID

2930: delete /*+ parallel(temp) */ from hz_purge_gt temp where
2931: temp.party_id in (select /*+ parallel(xx)*/ xx.PI_PARTY_ID from IGW_PROP_PERSON_SUPPORT xx
2932: );
2933: end if;
2934: --WSH_PARTY_SITES_V;PARTY_SITE_ID
2935: appid:=665;
2936: if(regid_proc = true) then
2937: insert into hz_application_trans_gt(app_id,party_id) select 665, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 665 and appl.party_id=temp.party_id) and
2938:

Line 2943: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from WSH_PARTY_SITES_V

2939: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
2940: xx
2941: where (nvl(STATUS, 'A') in ('A','I'))
2942: and xx.PARTY_SITE_ID
2943: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from WSH_PARTY_SITES_V
2944: yy
2945: ));
2946: else
2947: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 2952: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from WSH_PARTY_SITES_V

2948: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
2949: xx
2950: where (nvl(STATUS, 'A') in ('A','I'))
2951: and xx.PARTY_SITE_ID
2952: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from WSH_PARTY_SITES_V
2953: yy
2954: ));
2955: end if;
2956: --IGF_AP_FA_BASE_REC_ALL;PERSON_ID