APPS.HZ_PURGE_GEN dependencies on FUN_TRX_BATCHES

Line 3466: --FUN_TRX_BATCHES;INITIATOR_ID

3462: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3463: temp.party_id in (select /*+ parallel(xx)*/ xx.ROLLUP_PARTY_ID from OZF_ACCOUNT_ALLOCATIONS xx
3464: );
3465: end if;
3466: --FUN_TRX_BATCHES;INITIATOR_ID
3467: appid:=435;
3468: if(regid_proc = true) then
3469: 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
3470:

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

3467: appid:=435;
3468: if(regid_proc = true) then
3469: 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
3470:
3471: temp.party_id in (select /*+ parallel(xx)*/ xx.INITIATOR_ID from FUN_TRX_BATCHES xx
3472: );
3473: else
3474: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3475: temp.party_id in (select /*+ parallel(xx)*/ xx.INITIATOR_ID from FUN_TRX_BATCHES xx

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

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