APPS.IGS_AD_IMP_008 dependencies on IGS_PS_DEGREES

Line 2443: FROM igs_ps_degrees dg,

2439:
2440: -- Validate the DEGREE_CODE
2441: CURSOR c_degree_code (p_degree hz_education.degree_received%TYPE) IS
2442: SELECT dg.degree_cd
2443: FROM igs_ps_degrees dg,
2444: igs_ps_type_all ps
2445: WHERE dg.degree_cd = p_degree
2446: AND dg.closed_ind ='N'
2447: AND dg.program_type = ps.course_type;