APPS.HZ_PURGE_GEN dependencies on POS_PARTY_SITE_UDA_V

Line 3604: --POS_PARTY_SITE_UDA_V;PARTY_SITE_ID

3600: in (select /*+ parallel(yy)*/ yy.PARTY_ID from HZ_PARTY_USG_ASSIGNMENTS
3601: yy
3602: ));
3603: end if;
3604: --POS_PARTY_SITE_UDA_V;PARTY_SITE_ID
3605: appid:=177;
3606: if(regid_proc = true) then
3607: insert into hz_application_trans_gt(app_id,party_id) select 177, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 177 and appl.party_id=temp.party_id) and
3608:

Line 3613: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from POS_PARTY_SITE_UDA_V

3609: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3610: xx
3611: where (nvl(STATUS, 'A') in ('A','I'))
3612: and xx.PARTY_SITE_ID
3613: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from POS_PARTY_SITE_UDA_V
3614: yy
3615: ));
3616: else
3617: delete /*+ parallel(temp) */ from hz_purge_gt temp where

Line 3622: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from POS_PARTY_SITE_UDA_V

3618: temp.party_id in (select /*+ parallel (xx)*/ xx.PARTY_ID from HZ_PARTY_SITES
3619: xx
3620: where (nvl(STATUS, 'A') in ('A','I'))
3621: and xx.PARTY_SITE_ID
3622: in (select /*+ parallel(yy)*/ yy.PARTY_SITE_ID from POS_PARTY_SITE_UDA_V
3623: yy
3624: ));
3625: end if;
3626: --AP_SUPPLIERS;PARTY_ID