APPS.HZ_PURGE_GEN dependencies on FUN_SUPPLIER_MAPS

Line 3502: --FUN_SUPPLIER_MAPS;VENDOR_SITE_ID

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;
3504: if(regid_proc = true) then
3505: 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
3506:

Line 3511: in (select /*+ parallel(yy)*/ yy.VENDOR_SITE_ID from FUN_SUPPLIER_MAPS

3507: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3508: xx
3509: where (nvl(STATUS, 'A') in ('A','I'))
3510: and xx.PARTY_SITE_ID
3511: in (select /*+ parallel(yy)*/ yy.VENDOR_SITE_ID from FUN_SUPPLIER_MAPS
3512: yy
3513: ));
3514: else
3515: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 3520: in (select /*+ parallel(yy)*/ yy.VENDOR_SITE_ID from FUN_SUPPLIER_MAPS

3516: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3517: xx
3518: where (nvl(STATUS, 'A') in ('A','I'))
3519: and xx.PARTY_SITE_ID
3520: in (select /*+ parallel(yy)*/ yy.VENDOR_SITE_ID from FUN_SUPPLIER_MAPS
3521: yy
3522: ));
3523: end if;
3524: --XDP_ORDER_HEADERS;CUSTOMER_ID