DBA Data[Home] [Help]

APPS.HZ_PURGE_GEN dependencies on HZ_PERSON_INTEREST

Line 552: or exists (select 'Y' from HZ_PERSON_INTEREST

548: (select 'Y' from IGS_AD_HZ_EMP_DTL
549: yy where yy.EMPLOYMENT_HISTORY_ID=xx.EMPLOYMENT_HISTORY_ID
550: ))
551:
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

Line 632: or exists (select 'Y' from HZ_PERSON_INTEREST

628: (select 'Y' from IGS_AD_HZ_EMP_DTL
629: yy where yy.EMPLOYMENT_HISTORY_ID=xx.EMPLOYMENT_HISTORY_ID
630: ))
631:
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