APPS.HZ_PURGE_GEN dependencies on OZF_CLAIM_LINES_ALL

Line 3434: --OZF_CLAIM_LINES_ALL;BUY_GROUP_PARTY_ID

3430: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3431: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTNER_CONTACT_PARTY_ID from OZF_RESALE_BATCHES_ALL xx
3432: );
3433: end if;
3434: --OZF_CLAIM_LINES_ALL;BUY_GROUP_PARTY_ID
3435: appid:=682;
3436: if(regid_proc = true) then
3437: 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
3438:

Line 3439: temp.party_id in (select /*+ parallel(xx)*/ xx.BUY_GROUP_PARTY_ID from OZF_CLAIM_LINES_ALL xx

3435: appid:=682;
3436: if(regid_proc = true) then
3437: 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
3438:
3439: temp.party_id in (select /*+ parallel(xx)*/ xx.BUY_GROUP_PARTY_ID from OZF_CLAIM_LINES_ALL xx
3440: );
3441: else
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

Line 3443: temp.party_id in (select /*+ parallel(xx)*/ xx.BUY_GROUP_PARTY_ID from OZF_CLAIM_LINES_ALL xx

3439: temp.party_id in (select /*+ parallel(xx)*/ xx.BUY_GROUP_PARTY_ID from OZF_CLAIM_LINES_ALL xx
3440: );
3441: else
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;