APPS.HZ_PURGE_GEN dependencies on IBW_PAGE_VIEWS

Line 5228: --IBW_PAGE_VIEWS;PARTY_ID

5224: in (select /*+ parallel(yy)*/ yy.AUTHORITY_SITE_ID from XLE_REG_FUNCTIONS
5225: yy
5226: ));
5227: end if;
5228: --IBW_PAGE_VIEWS;PARTY_ID
5229: appid:=666;
5230: if(regid_proc = true) then
5231: 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
5232:

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

5229: appid:=666;
5230: if(regid_proc = true) then
5231: 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
5232:
5233: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IBW_PAGE_VIEWS xx
5234: );
5235: else
5236: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5237: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IBW_PAGE_VIEWS xx

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

5233: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IBW_PAGE_VIEWS xx
5234: );
5235: else
5236: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5237: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IBW_PAGE_VIEWS xx
5238: );
5239: end if;
5240: --IBW_PAGE_VIEWS;PARTY_RELATIONSHIP_ID
5241: appid:=666;

Line 5240: --IBW_PAGE_VIEWS;PARTY_RELATIONSHIP_ID

5236: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5237: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IBW_PAGE_VIEWS xx
5238: );
5239: end if;
5240: --IBW_PAGE_VIEWS;PARTY_RELATIONSHIP_ID
5241: appid:=666;
5242: if(regid_proc = true) then
5243: 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
5244:

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

5241: appid:=666;
5242: if(regid_proc = true) then
5243: 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
5244:
5245: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_RELATIONSHIP_ID from IBW_PAGE_VIEWS xx
5246: );
5247: else
5248: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5249: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_RELATIONSHIP_ID from IBW_PAGE_VIEWS xx

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

5245: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_RELATIONSHIP_ID from IBW_PAGE_VIEWS xx
5246: );
5247: else
5248: delete /*+ parallel(temp) */ from hz_purge_gt temp where
5249: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_RELATIONSHIP_ID from IBW_PAGE_VIEWS xx
5250: );
5251: end if;
5252: if(regid_proc = true) then
5253: delete from hz_purge_gt temp where temp.party_id in (select appl.party_id from hz_application_trans_gt appl) ;