APPS.HZ_PURGE_GEN dependencies on OZF_CLAIMS_HISTORY_ALL

Line 3098: --OZF_CLAIMS_HISTORY_ALL;BROKER_ID

3094: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3095: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IBE_ACTIVE_QUOTES_ALL xx
3096: );
3097: end if;
3098: --OZF_CLAIMS_HISTORY_ALL;BROKER_ID
3099: appid:=682;
3100: if(regid_proc = true) then
3101: insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and
3102:

Line 3103: temp.party_id in (select /*+ parallel(xx)*/ xx.BROKER_ID from OZF_CLAIMS_HISTORY_ALL xx

3099: appid:=682;
3100: if(regid_proc = true) then
3101: insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and
3102:
3103: temp.party_id in (select /*+ parallel(xx)*/ xx.BROKER_ID from OZF_CLAIMS_HISTORY_ALL xx
3104: );
3105: else
3106: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3107: temp.party_id in (select /*+ parallel(xx)*/ xx.BROKER_ID from OZF_CLAIMS_HISTORY_ALL xx

Line 3107: temp.party_id in (select /*+ parallel(xx)*/ xx.BROKER_ID from OZF_CLAIMS_HISTORY_ALL xx

3103: temp.party_id in (select /*+ parallel(xx)*/ xx.BROKER_ID from OZF_CLAIMS_HISTORY_ALL xx
3104: );
3105: else
3106: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3107: temp.party_id in (select /*+ parallel(xx)*/ xx.BROKER_ID from OZF_CLAIMS_HISTORY_ALL xx
3108: );
3109: end if;
3110: --OZF_CLAIMS_HISTORY_ALL;CONTACT_ID
3111: appid:=682;

Line 3110: --OZF_CLAIMS_HISTORY_ALL;CONTACT_ID

3106: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3107: temp.party_id in (select /*+ parallel(xx)*/ xx.BROKER_ID from OZF_CLAIMS_HISTORY_ALL xx
3108: );
3109: end if;
3110: --OZF_CLAIMS_HISTORY_ALL;CONTACT_ID
3111: appid:=682;
3112: if(regid_proc = true) then
3113: insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and
3114:

Line 3115: temp.party_id in (select /*+ parallel(xx)*/ xx.CONTACT_ID from OZF_CLAIMS_HISTORY_ALL xx

3111: appid:=682;
3112: if(regid_proc = true) then
3113: insert into hz_application_trans_gt(app_id,party_id) select 682, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 682 and appl.party_id=temp.party_id) and
3114:
3115: temp.party_id in (select /*+ parallel(xx)*/ xx.CONTACT_ID from OZF_CLAIMS_HISTORY_ALL xx
3116: );
3117: else
3118: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3119: temp.party_id in (select /*+ parallel(xx)*/ xx.CONTACT_ID from OZF_CLAIMS_HISTORY_ALL xx

Line 3119: temp.party_id in (select /*+ parallel(xx)*/ xx.CONTACT_ID from OZF_CLAIMS_HISTORY_ALL xx

3115: temp.party_id in (select /*+ parallel(xx)*/ xx.CONTACT_ID from OZF_CLAIMS_HISTORY_ALL xx
3116: );
3117: else
3118: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3119: temp.party_id in (select /*+ parallel(xx)*/ xx.CONTACT_ID from OZF_CLAIMS_HISTORY_ALL xx
3120: );
3121: end if;
3122: --OZF_RESALE_LINES_INT_ALL;SHIP_FROM_CONTACT_PARTY_ID
3123: appid:=682;