APPS.HZ_PURGE_GEN dependencies on IBW_PAGE_VIEWS

Line 5448: --IBW_PAGE_VIEWS;PARTY_ID

5444: in (select /*+ parallel(yy)*/ yy.AUTHORITY_SITE_ID from XLE_REG_FUNCTIONS
5445: yy
5446: ));
5447: end if;
5448: --IBW_PAGE_VIEWS;PARTY_ID
5449: appid:=666;
5450: if(regid_proc = true) then
5451: insert into hz_application_trans_gt(app_id,party_id) select 666, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 666 and appl.party_id=temp.party_id) and
5452:

Line 5453: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IBW_PAGE_VIEWS xx

5449: appid:=666;
5450: if(regid_proc = true) then
5451: insert into hz_application_trans_gt(app_id,party_id) select 666, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 666 and appl.party_id=temp.party_id) and
5452:
5453: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IBW_PAGE_VIEWS xx
5454: );
5455: else
5456: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5457: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IBW_PAGE_VIEWS xx

Line 5457: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IBW_PAGE_VIEWS xx

5453: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IBW_PAGE_VIEWS xx
5454: );
5455: else
5456: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5457: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IBW_PAGE_VIEWS xx
5458: );
5459: end if;
5460: --IBW_PAGE_VIEWS;PARTY_RELATIONSHIP_ID
5461: appid:=666;

Line 5460: --IBW_PAGE_VIEWS;PARTY_RELATIONSHIP_ID

5456: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5457: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IBW_PAGE_VIEWS xx
5458: );
5459: end if;
5460: --IBW_PAGE_VIEWS;PARTY_RELATIONSHIP_ID
5461: appid:=666;
5462: if(regid_proc = true) then
5463: insert into hz_application_trans_gt(app_id,party_id) select 666, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 666 and appl.party_id=temp.party_id) and
5464:

Line 5465: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_RELATIONSHIP_ID from IBW_PAGE_VIEWS xx

5461: appid:=666;
5462: if(regid_proc = true) then
5463: insert into hz_application_trans_gt(app_id,party_id) select 666, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 666 and appl.party_id=temp.party_id) and
5464:
5465: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_RELATIONSHIP_ID from IBW_PAGE_VIEWS xx
5466: );
5467: else
5468: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5469: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_RELATIONSHIP_ID from IBW_PAGE_VIEWS xx

Line 5469: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_RELATIONSHIP_ID from IBW_PAGE_VIEWS xx

5465: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_RELATIONSHIP_ID from IBW_PAGE_VIEWS xx
5466: );
5467: else
5468: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5469: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_RELATIONSHIP_ID from IBW_PAGE_VIEWS xx
5470: );
5471: end if;
5472: if(regid_proc = true) then
5473: delete from hz_purge_gt temp where temp.party_id in (select appl.party_id from hz_application_trans_gt appl) ;