APPS.HZ_PURGE_GEN dependencies on OZF_ACCOUNT_ALLOCATIONS

Line 3446: --OZF_ACCOUNT_ALLOCATIONS;PARENT_PARTY_ID

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

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

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

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

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

Line 3458: --OZF_ACCOUNT_ALLOCATIONS;ROLLUP_PARTY_ID

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

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

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

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

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