DBA Data[Home] [Help]

APPS.IGS_AD_ACAD_HISTORY_PKG dependencies on IGS_PS_DEGREES

Line 89: FROM igs_ps_degrees dg,

85: AND php.party_id = hz.party_id ;
86:
87: CURSOR c_degree_code (p_degree hz_education.degree_received%TYPE) IS
88: SELECT dg.degree_cd
89: FROM igs_ps_degrees dg,
90: igs_ps_type_all ps
91: WHERE dg.degree_cd = p_degree
92: AND dg.closed_ind ='N'
93: AND dg.program_type = ps.course_type;

Line 449: FROM igs_ps_degrees dg

445: AND exemption_institution_cd = p_party_number;
446:
447: CURSOR c_degree_code (p_degree hz_education.degree_received%TYPE) IS
448: SELECT dg.degree_cd
449: FROM igs_ps_degrees dg
450: WHERE dg.degree_cd = p_degree
451: AND dg.closed_ind ='N'
452: AND dg.program_type IS NOT NULL;
453: