APPS.IGS_AD_SS_GEN_001 dependencies on IGS_PE_PERSON_ALIAS_V

Line 3643: FROM IGS_PE_PERSON_ALIAS_V pon

3639:
3640: -- Other Names- OTHER_NAMES
3641: CURSOR c_other_Names(cp_person_id igs_ad_appl.person_id%TYPE, cp_ApplType igs_ad_appl.APPLICATION_TYPE%TYPE) IS
3642: SELECT 'x'
3643: FROM IGS_PE_PERSON_ALIAS_V pon
3644: WHERE pon.PERSON_ID = cp_person_id
3645: AND ALIAS_TYPE IN
3646: (SELECT SS_Lookup_code
3647: FROM igs_ad_ss_lookups