APPS.IGS_AD_SS_GEN_001 dependencies on IGS_PE_RACE

Line 3654: -- check only in IGS_PE_RACE

3650: AND Closed_flag <> 'Y');
3651: -- Ask PM for Date Check
3652:
3653: -- Biographic- BIOGRAPHIC
3654: -- check only in IGS_PE_RACE
3655: CURSOR c_race (cp_person_id igs_ad_appl.person_id%TYPE) IS
3656: SELECT 'x'
3657: FROM IGS_PE_RACE race
3658: WHERE race.PERSON_ID = cp_person_id;

Line 3657: FROM IGS_PE_RACE race

3653: -- Biographic- BIOGRAPHIC
3654: -- check only in IGS_PE_RACE
3655: CURSOR c_race (cp_person_id igs_ad_appl.person_id%TYPE) IS
3656: SELECT 'x'
3657: FROM IGS_PE_RACE race
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