APPS.HZ_PURGE_GEN dependencies on WSH_PARTY_SITES_V

Line 2988: --WSH_PARTY_SITES_V;PARTY_SITE_ID

2984: );
2985: end if;
2986:
2987:
2988: --WSH_PARTY_SITES_V;PARTY_SITE_ID
2989: appid:=665;
2990: if(regid_proc = true) then
2991: 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
2992:

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

2993: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
2994: xx
2995: where (nvl(STATUS, 'A') in ('A','I'))
2996: and xx.PARTY_SITE_ID
2997: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from WSH_PARTY_SITES_V
2998: yy
2999: ));
3000: else
3001: delete /*+ parallel(temp) */ from hz_purge_gt temp where

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

3002: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3003: xx
3004: where (nvl(STATUS, 'A') in ('A','I'))
3005: and xx.PARTY_SITE_ID
3006: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from WSH_PARTY_SITES_V
3007: yy
3008: ));
3009: end if;
3010: --HZ_WORK_CLASS;EMPLOYMENT_HISTORY_ID