APPS.HZ_PURGE_GEN dependencies on OZF_CLAIMS_HISTORY_ALL

Line 3094: --OZF_CLAIMS_HISTORY_ALL;BROKER_ID

3090: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3091: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IBE_ACTIVE_QUOTES_ALL xx
3092: );
3093: end if;
3094: --OZF_CLAIMS_HISTORY_ALL;BROKER_ID
3095: appid:=682;
3096: if(regid_proc = true) then
3097: 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
3098:

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

3095: appid:=682;
3096: if(regid_proc = true) then
3097: 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
3098:
3099: temp.party_id in (select /*+ parallel(xx)*/ xx.BROKER_ID from OZF_CLAIMS_HISTORY_ALL xx
3100: );
3101: else
3102: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3103: temp.party_id in (select /*+ parallel(xx)*/ xx.BROKER_ID from OZF_CLAIMS_HISTORY_ALL xx

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

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

Line 3106: --OZF_CLAIMS_HISTORY_ALL;CONTACT_ID

3102: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3103: temp.party_id in (select /*+ parallel(xx)*/ xx.BROKER_ID from OZF_CLAIMS_HISTORY_ALL xx
3104: );
3105: end if;
3106: --OZF_CLAIMS_HISTORY_ALL;CONTACT_ID
3107: appid:=682;
3108: if(regid_proc = true) then
3109: 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
3110:

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

3107: appid:=682;
3108: if(regid_proc = true) then
3109: 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
3110:
3111: temp.party_id in (select /*+ parallel(xx)*/ xx.CONTACT_ID from OZF_CLAIMS_HISTORY_ALL xx
3112: );
3113: else
3114: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3115: temp.party_id in (select /*+ parallel(xx)*/ xx.CONTACT_ID from OZF_CLAIMS_HISTORY_ALL xx

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

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