DBA Data[Home] [Help]

APPS.HZ_PURGE_GEN dependencies on IGS_AD_HZ_EXTRACURR_ACT

Line 556: (select 'Y' from IGS_AD_HZ_EXTRACURR_ACT

552: or exists (select 'Y' from HZ_PERSON_INTEREST
553: xx where xx.PARTY_ID = temp.party_id
554: and (nvl(STATUS, 'A') in ('A','I'))
555: and exists
556: (select 'Y' from IGS_AD_HZ_EXTRACURR_ACT
557: yy where yy.PERSON_INTEREST_ID=xx.PERSON_INTEREST_ID
558: ))
559:
560: or exists (select 'Y' from HZ_EDUCATION

Line 636: (select 'Y' from IGS_AD_HZ_EXTRACURR_ACT

632: or exists (select 'Y' from HZ_PERSON_INTEREST
633: xx where xx.PARTY_ID = temp.party_id
634: and (nvl(STATUS, 'A') in ('A','I'))
635: and exists
636: (select 'Y' from IGS_AD_HZ_EXTRACURR_ACT
637: yy where yy.PERSON_INTEREST_ID=xx.PERSON_INTEREST_ID
638: ))
639:
640: or exists (select 'Y' from HZ_EDUCATION