APPS.HZ_PURGE_GEN dependencies on FUN_TRX_BATCHES

Line 3470: --FUN_TRX_BATCHES;INITIATOR_ID

3466: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3467: temp.party_id in (select /*+ parallel(xx)*/ xx.ROLLUP_PARTY_ID from OZF_ACCOUNT_ALLOCATIONS xx
3468: );
3469: end if;
3470: --FUN_TRX_BATCHES;INITIATOR_ID
3471: appid:=435;
3472: if(regid_proc = true) then
3473: insert into hz_application_trans_gt(app_id,party_id) select 435, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 435 and appl.party_id=temp.party_id) and
3474:

Line 3475: temp.party_id in (select /*+ parallel(xx)*/ xx.INITIATOR_ID from FUN_TRX_BATCHES xx

3471: appid:=435;
3472: if(regid_proc = true) then
3473: insert into hz_application_trans_gt(app_id,party_id) select 435, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 435 and appl.party_id=temp.party_id) and
3474:
3475: temp.party_id in (select /*+ parallel(xx)*/ xx.INITIATOR_ID from FUN_TRX_BATCHES xx
3476: );
3477: else
3478: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3479: temp.party_id in (select /*+ parallel(xx)*/ xx.INITIATOR_ID from FUN_TRX_BATCHES xx

Line 3479: temp.party_id in (select /*+ parallel(xx)*/ xx.INITIATOR_ID from FUN_TRX_BATCHES xx

3475: temp.party_id in (select /*+ parallel(xx)*/ xx.INITIATOR_ID from FUN_TRX_BATCHES xx
3476: );
3477: else
3478: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3479: temp.party_id in (select /*+ parallel(xx)*/ xx.INITIATOR_ID from FUN_TRX_BATCHES xx
3480: );
3481: end if;
3482: --FUN_TRX_HEADERS;RECIPIENT_ID
3483: appid:=435;