APPS.HZ_PURGE_GEN dependencies on OZF_CLAIM_LINES_HIST_ALL

Line 3410: --OZF_CLAIM_LINES_HIST_ALL;BUY_GROUP_PARTY_ID

3406: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3407: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from OZF_ACTIVITY_CUSTOMERS xx
3408: );
3409: end if;
3410: --OZF_CLAIM_LINES_HIST_ALL;BUY_GROUP_PARTY_ID
3411: appid:=682;
3412: if(regid_proc = true) then
3413: 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
3414:

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

3411: appid:=682;
3412: if(regid_proc = true) then
3413: 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
3414:
3415: temp.party_id in (select /*+ parallel(xx)*/ xx.BUY_GROUP_PARTY_ID from OZF_CLAIM_LINES_HIST_ALL xx
3416: );
3417: else
3418: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3419: temp.party_id in (select /*+ parallel(xx)*/ xx.BUY_GROUP_PARTY_ID from OZF_CLAIM_LINES_HIST_ALL xx

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

3415: temp.party_id in (select /*+ parallel(xx)*/ xx.BUY_GROUP_PARTY_ID from OZF_CLAIM_LINES_HIST_ALL xx
3416: );
3417: else
3418: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3419: temp.party_id in (select /*+ parallel(xx)*/ xx.BUY_GROUP_PARTY_ID from OZF_CLAIM_LINES_HIST_ALL xx
3420: );
3421: end if;
3422: --OZF_RESALE_BATCHES_ALL;PARTNER_CONTACT_PARTY_ID
3423: appid:=682;