APPS.IGS_AD_SS_GEN_001 dependencies on IGS_PE_PERS_DISABLTY

Line 3662: SELECT 'x' FROM IGS_PE_PERS_DISABLTY WHERE person_id = cp_person_id

3658: WHERE race.PERSON_ID = cp_person_id;
3659:
3660: -- Special Needs- SPECIAL_NEEDS
3661: CURSOR c_spl_Needs(cp_person_id igs_ad_appl.person_id%TYPE) IS
3662: SELECT 'x' FROM IGS_PE_PERS_DISABLTY WHERE person_id = cp_person_id
3663: AND SYSDATE <= NVL(END_DATE,SYSDATE);
3664:
3665: -- Privacy- PRIVACY
3666: CURSOR c_privacy(cp_person_id igs_ad_appl.person_id%TYPE, cp_ApplType igs_ad_appl.APPLICATION_TYPE%TYPE) IS