APPS.IGS_HE_EXTRACT_PKG dependencies on IGS_PS_AWARD

Line 1108: FROM igs_ps_award

1104: (p_course_cd igs_he_st_spa.course_cd%TYPE,
1105: p_version_number igs_he_st_spa.version_number%TYPE)
1106: IS
1107: SELECT award_cd
1108: FROM igs_ps_award
1109: WHERE course_cd = p_course_cd
1110: AND version_number = p_version_number
1111: AND closed_ind = 'N' ;
1112:

Line 1257: l_award_cd igs_ps_award.award_cd%TYPE;

1253: l_enrolled_su c_enr_su%ROWTYPE ;
1254: l_valid BOOLEAN := TRUE;
1255: l_rowid VARCHAR2(50);
1256: l_ext_interim_id NUMBER;
1257: l_award_cd igs_ps_award.award_cd%TYPE;
1258: l_rec_count NUMBER := 0;
1259: l_message VARCHAR2(2000);
1260: l_return_type VARCHAR2(3);
1261: l_api_person_id igs_pe_alt_pers_id.api_person_id%TYPE;