APPS.IGS_AD_SS_GEN_001 dependencies on HZ_CITIZENSHIP
Line 3757: FROM HZ_CITIZENSHIP cz
3753:
3754: -- Country of Citizenship- COUNTRY_CITIZENSHIP
3755: CURSOR c_citizenship(cp_person_id igs_ad_appl.person_id%TYPE) IS
3756: SELECT 'x' 3757: FROM HZ_CITIZENSHIP cz 3758: WHERE cz.PARTY_ID = cp_person_id
3759: AND cz.STATUS = 'A';
3760:
3761: -- Visa- VISA