APPS.HZ_PURGE_GEN dependencies on FUN_SUPPLIER_MAPS

Line 3506: --FUN_SUPPLIER_MAPS;VENDOR_SITE_ID

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;
3508: if(regid_proc = true) then
3509: 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
3510:

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

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

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

3520: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3521: xx
3522: where (nvl(STATUS, 'A') in ('A','I'))
3523: and xx.PARTY_SITE_ID
3524: in (select /*+ parallel(yy)*/ yy.VENDOR_SITE_ID from FUN_SUPPLIER_MAPS
3525: yy
3526: ));
3527: end if;
3528: --IGS_PE_STAT_DETAILS;PERSON_PROFILE_ID