APPS.HZ_PURGE_GEN dependencies on FUN_DIST_LINES

Line 3490: --FUN_DIST_LINES;PARTY_ID

3486: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3487: temp.party_id in (select /*+ parallel(xx)*/ xx.RECIPIENT_ID from FUN_TRX_HEADERS xx
3488: );
3489: end if;
3490: --FUN_DIST_LINES;PARTY_ID
3491: appid:=435;
3492: if(regid_proc = true) then
3493: 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
3494:

Line 3495: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from FUN_DIST_LINES xx

3491: appid:=435;
3492: if(regid_proc = true) then
3493: 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
3494:
3495: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from FUN_DIST_LINES xx
3496: );
3497: else
3498: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3499: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from FUN_DIST_LINES xx

Line 3499: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from FUN_DIST_LINES xx

3495: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from FUN_DIST_LINES xx
3496: );
3497: else
3498: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3499: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from FUN_DIST_LINES xx
3500: );
3501: end if;
3502: --FUN_SUPPLIER_MAPS;VENDOR_SITE_ID
3503: appid:=435;