APPS.HZ_PURGE_GEN dependencies on IGS_FI_REFUNDS

Line 593: or exists (select 'Y' from IGS_FI_REFUNDS xx where xx.PERSON_ID = temp.party_id

589:
590: or exists (select 'Y' from IGS_FI_P_SA_NOTES xx where xx.PARTY_ID = temp.party_id
591: )
592:
593: or exists (select 'Y' from IGS_FI_REFUNDS xx where xx.PERSON_ID = temp.party_id
594: )
595:
596: or exists (select 'Y' from IGP_AC_ACCOUNTS xx where xx.PARTY_ID = temp.party_id
597: );

Line 673: or exists (select 'Y' from IGS_FI_REFUNDS xx where xx.PERSON_ID = temp.party_id

669:
670: or exists (select 'Y' from IGS_FI_P_SA_NOTES xx where xx.PARTY_ID = temp.party_id
671: )
672:
673: or exists (select 'Y' from IGS_FI_REFUNDS xx where xx.PERSON_ID = temp.party_id
674: )
675:
676: or exists (select 'Y' from IGP_AC_ACCOUNTS xx where xx.PARTY_ID = temp.party_id
677: );

Line 3550: --IGS_FI_REFUNDS;PAY_PERSON_ID

3546: in (select /*+ parallel(yy)*/ yy.PERSON_PROFILE_ID from IGS_PE_STAT_DETAILS
3547: yy
3548: ));
3549: end if;
3550: --IGS_FI_REFUNDS;PAY_PERSON_ID
3551: appid:=8405;
3552: if(regid_proc = true) then
3553: 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
3554:

Line 3555: temp.party_id in (select /*+ parallel(xx)*/ xx.PAY_PERSON_ID from IGS_FI_REFUNDS xx

3551: appid:=8405;
3552: if(regid_proc = true) then
3553: 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
3554:
3555: temp.party_id in (select /*+ parallel(xx)*/ xx.PAY_PERSON_ID from IGS_FI_REFUNDS xx
3556: );
3557: else
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

Line 3559: temp.party_id in (select /*+ parallel(xx)*/ xx.PAY_PERSON_ID from IGS_FI_REFUNDS xx

3555: temp.party_id in (select /*+ parallel(xx)*/ xx.PAY_PERSON_ID from IGS_FI_REFUNDS xx
3556: );
3557: else
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;