APPS.HZ_PURGE_GEN dependencies on OZF_ACCOUNT_ALLOCATIONS

Line 3442: --OZF_ACCOUNT_ALLOCATIONS;PARENT_PARTY_ID

3438: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3439: temp.party_id in (select /*+ parallel(xx)*/ xx.BUY_GROUP_PARTY_ID from OZF_CLAIM_LINES_ALL xx
3440: );
3441: end if;
3442: --OZF_ACCOUNT_ALLOCATIONS;PARENT_PARTY_ID
3443: appid:=682;
3444: if(regid_proc = true) then
3445: 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
3446:

Line 3447: temp.party_id in (select /*+ parallel(xx)*/ xx.PARENT_PARTY_ID from OZF_ACCOUNT_ALLOCATIONS xx

3443: appid:=682;
3444: if(regid_proc = true) then
3445: 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
3446:
3447: temp.party_id in (select /*+ parallel(xx)*/ xx.PARENT_PARTY_ID from OZF_ACCOUNT_ALLOCATIONS xx
3448: );
3449: else
3450: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3451: temp.party_id in (select /*+ parallel(xx)*/ xx.PARENT_PARTY_ID from OZF_ACCOUNT_ALLOCATIONS xx

Line 3451: temp.party_id in (select /*+ parallel(xx)*/ xx.PARENT_PARTY_ID from OZF_ACCOUNT_ALLOCATIONS xx

3447: temp.party_id in (select /*+ parallel(xx)*/ xx.PARENT_PARTY_ID from OZF_ACCOUNT_ALLOCATIONS xx
3448: );
3449: else
3450: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3451: temp.party_id in (select /*+ parallel(xx)*/ xx.PARENT_PARTY_ID from OZF_ACCOUNT_ALLOCATIONS xx
3452: );
3453: end if;
3454: --OZF_ACCOUNT_ALLOCATIONS;ROLLUP_PARTY_ID
3455: appid:=682;

Line 3454: --OZF_ACCOUNT_ALLOCATIONS;ROLLUP_PARTY_ID

3450: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3451: temp.party_id in (select /*+ parallel(xx)*/ xx.PARENT_PARTY_ID from OZF_ACCOUNT_ALLOCATIONS xx
3452: );
3453: end if;
3454: --OZF_ACCOUNT_ALLOCATIONS;ROLLUP_PARTY_ID
3455: appid:=682;
3456: if(regid_proc = true) then
3457: 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
3458:

Line 3459: temp.party_id in (select /*+ parallel(xx)*/ xx.ROLLUP_PARTY_ID from OZF_ACCOUNT_ALLOCATIONS xx

3455: appid:=682;
3456: if(regid_proc = true) then
3457: 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
3458:
3459: temp.party_id in (select /*+ parallel(xx)*/ xx.ROLLUP_PARTY_ID from OZF_ACCOUNT_ALLOCATIONS xx
3460: );
3461: else
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

Line 3463: temp.party_id in (select /*+ parallel(xx)*/ xx.ROLLUP_PARTY_ID from OZF_ACCOUNT_ALLOCATIONS xx

3459: temp.party_id in (select /*+ parallel(xx)*/ xx.ROLLUP_PARTY_ID from OZF_ACCOUNT_ALLOCATIONS xx
3460: );
3461: else
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;