APPS.HZ_PURGE_GEN dependencies on IGS_AD_HZ_EMP_DTL

Line 541: (select 'Y' from IGS_AD_HZ_EMP_DTL

537: or exists (select 'Y' from HZ_EMPLOYMENT_HISTORY
538: xx where xx.PARTY_ID = temp.party_id
539: and (nvl(STATUS, 'A') in ('A','I'))
540: and exists
541: (select 'Y' from IGS_AD_HZ_EMP_DTL
542: yy where yy.EMPLOYMENT_HISTORY_ID=xx.EMPLOYMENT_HISTORY_ID
543: ))
544: or exists (select 'Y' from HZ_EMPLOYMENT_HISTORY
545: xx where xx.EMPLOYED_BY_PARTY_ID = temp.party_id

Line 548: (select 'Y' from IGS_AD_HZ_EMP_DTL

544: or exists (select 'Y' from HZ_EMPLOYMENT_HISTORY
545: xx where xx.EMPLOYED_BY_PARTY_ID = temp.party_id
546: and (nvl(STATUS,'A') in ('A','I'))
547: and exists
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

Line 621: (select 'Y' from IGS_AD_HZ_EMP_DTL

617: or exists (select 'Y' from HZ_EMPLOYMENT_HISTORY
618: xx where xx.PARTY_ID = temp.party_id
619: and (nvl(STATUS, 'A') in ('A','I'))
620: and exists
621: (select 'Y' from IGS_AD_HZ_EMP_DTL
622: yy where yy.EMPLOYMENT_HISTORY_ID=xx.EMPLOYMENT_HISTORY_ID
623: ))
624: or exists (select 'Y' from HZ_EMPLOYMENT_HISTORY
625: xx where xx.EMPLOYED_BY_PARTY_ID = temp.party_id

Line 628: (select 'Y' from IGS_AD_HZ_EMP_DTL

624: or exists (select 'Y' from HZ_EMPLOYMENT_HISTORY
625: xx where xx.EMPLOYED_BY_PARTY_ID = temp.party_id
626: and (nvl(STATUS,'A') in ('A','I'))
627: and exists
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