APPS.HZ_PURGE_GEN dependencies on IGP_AC_ACCOUNT_INTS

Line 3562: --IGP_AC_ACCOUNT_INTS;PARTY_ID

3558: delete /*+ parallel(temp) */ from hz_purge_gt temp where
3559: temp.party_id in (select /*+ parallel(xx)*/ xx.PAY_PERSON_ID from IGS_FI_REFUNDS xx
3560: );
3561: end if;
3562: --IGP_AC_ACCOUNT_INTS;PARTY_ID
3563: appid:=8405;
3564: if(regid_proc = true) then
3565: 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
3566:

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

3563: appid:=8405;
3564: if(regid_proc = true) then
3565: 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
3566:
3567: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IGP_AC_ACCOUNT_INTS xx
3568: );
3569: else
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

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

3567: temp.party_id in (select /*+ parallel(xx)*/ xx.PARTY_ID from IGP_AC_ACCOUNT_INTS xx
3568: );
3569: else
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;