APPS.HZ_PURGE_GEN dependencies on FUN_DIST_LINES

Line 3494: --FUN_DIST_LINES;PARTY_ID

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

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

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

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

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