APPS.HZ_PURGE_GEN dependencies on IGP_US_REG_VIEWERS

Line 3574: --IGP_US_REG_VIEWERS;ORG_PARTY_ID

3570: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3571: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IGP_AC_ACCOUNT_INTS xx
3572: );
3573: end if;
3574: --IGP_US_REG_VIEWERS;ORG_PARTY_ID
3575: appid:=8405;
3576: if(regid_proc = true) then
3577: insert into hz_application_trans_gt(app_id,party_id) select 8405, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 8405 and appl.party_id=temp.party_id) and
3578:

Line 3579: temp.party_id in (select /*+ parallel(xx)*/ xx.ORG_PARTY_ID from IGP_US_REG_VIEWERS xx

3575: appid:=8405;
3576: if(regid_proc = true) then
3577: insert into hz_application_trans_gt(app_id,party_id) select 8405, temp.party_id from hz_purge_gt temp where not exists(select 'Y' from hz_application_trans_gt appl where appl.app_id = 8405 and appl.party_id=temp.party_id) and
3578:
3579: temp.party_id in (select /*+ parallel(xx)*/ xx.ORG_PARTY_ID from IGP_US_REG_VIEWERS xx
3580: );
3581: else
3582: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3583: temp.party_id in (select /*+ parallel(xx)*/ xx.ORG_PARTY_ID from IGP_US_REG_VIEWERS xx

Line 3583: temp.party_id in (select /*+ parallel(xx)*/ xx.ORG_PARTY_ID from IGP_US_REG_VIEWERS xx

3579: temp.party_id in (select /*+ parallel(xx)*/ xx.ORG_PARTY_ID from IGP_US_REG_VIEWERS xx
3580: );
3581: else
3582: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3583: temp.party_id in (select /*+ parallel(xx)*/ xx.ORG_PARTY_ID from IGP_US_REG_VIEWERS xx
3584: );
3585: end if;
3586: --XDP_ORDER_HEADERS;CUSTOMER_ID
3587: appid:=535;