APPS.IGF_SP_AWARD dependencies on IGS_EN_STDNT_PS_ATT

Line 514: CURSOR c_prg_attempt (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

510: WHERE fee_cls_prg_id = cp_fee_cls_prg_id;
511: rec_std_unit c_std_unit%ROWTYPE;
512:
513: -- cursor to check forprg attempt
514: CURSOR c_prg_attempt (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
515: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
516: cp_course_version_number igs_en_stdnt_ps_att.version_number%TYPE,
517: cp_v_load_cal_type igs_ca_inst_all.cal_type%TYPE,
518: cp_n_load_seq_num igs_ca_inst_all.sequence_number%TYPE) IS

Line 515: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,

511: rec_std_unit c_std_unit%ROWTYPE;
512:
513: -- cursor to check forprg attempt
514: CURSOR c_prg_attempt (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
515: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
516: cp_course_version_number igs_en_stdnt_ps_att.version_number%TYPE,
517: cp_v_load_cal_type igs_ca_inst_all.cal_type%TYPE,
518: cp_n_load_seq_num igs_ca_inst_all.sequence_number%TYPE) IS
519: SELECT 'x'

Line 516: cp_course_version_number igs_en_stdnt_ps_att.version_number%TYPE,

512:
513: -- cursor to check forprg attempt
514: CURSOR c_prg_attempt (cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
515: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
516: cp_course_version_number igs_en_stdnt_ps_att.version_number%TYPE,
517: cp_v_load_cal_type igs_ca_inst_all.cal_type%TYPE,
518: cp_n_load_seq_num igs_ca_inst_all.sequence_number%TYPE) IS
519: SELECT 'x'
520: FROM igs_en_stdnt_ps_att psatt

Line 520: FROM igs_en_stdnt_ps_att psatt

516: cp_course_version_number igs_en_stdnt_ps_att.version_number%TYPE,
517: cp_v_load_cal_type igs_ca_inst_all.cal_type%TYPE,
518: cp_n_load_seq_num igs_ca_inst_all.sequence_number%TYPE) IS
519: SELECT 'x'
520: FROM igs_en_stdnt_ps_att psatt
521: WHERE person_id = cp_person_id
522: AND course_cd = cp_course_cd
523: AND version_number = cp_course_version_number
524: AND course_attempt_status IN ('ENROLLED','INACTIVE','DISCONTIN')