APPS.IGF_SL_REL_DISB dependencies on IGS_EN_STDNT_PS_ATT

Line 673: l_program_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;

669: WHERE p_award_id = award_id AND p_disb_num = disb_num;
670:
671: get_disb_date_rec cur_get_disb_date%ROWTYPE;
672: l_pell_setup_rec igf_gr_pell_setup_all%ROWTYPE;
673: l_program_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;
674: l_program_version igs_en_stdnt_ps_att_all.version_number%TYPE;
675: l_message fnd_new_messages.message_text%TYPE;
676: l_return_status VARCHAR2(30);
677: BEGIN

Line 674: l_program_version igs_en_stdnt_ps_att_all.version_number%TYPE;

670:
671: get_disb_date_rec cur_get_disb_date%ROWTYPE;
672: l_pell_setup_rec igf_gr_pell_setup_all%ROWTYPE;
673: l_program_cd igs_en_stdnt_ps_att_all.course_cd%TYPE;
674: l_program_version igs_en_stdnt_ps_att_all.version_number%TYPE;
675: l_message fnd_new_messages.message_text%TYPE;
676: l_return_status VARCHAR2(30);
677: BEGIN
678: -- Get the students key program details

Line 1048: FROM igs_en_su_attempt su, igs_en_stdnt_ps_att pg

1044: )
1045: IS
1046: SELECT pg.course_cd prg_course_cd, pg.version_number prg_ver_num,
1047: su.unit_cd unit_course_cd, su.version_number unit_ver_num
1048: FROM igs_en_su_attempt su, igs_en_stdnt_ps_att pg
1049: WHERE su.person_id = p_person_id AND pg.person_id = su.person_id
1050: AND su.unit_attempt_status IN
1051: ('COMPLETED', 'ENROLLED', 'DUPLICATE')
1052: AND su.cal_type = p_tp_cal_type