APPS.IGS_AS_CALC_AWARD_MARK dependencies on IGS_EN_STDNT_PS_ATT

Line 339: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,

335: exlude_cp NUMBER;
336:
337: -- CURSOR to get the COURSE CODE version NUMBER
338: CURSOR c_course_version_number (
339: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
340: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE
341: )
342: IS
343: SELECT version_number

Line 340: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE

336:
337: -- CURSOR to get the COURSE CODE version NUMBER
338: CURSOR c_course_version_number (
339: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
340: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE
341: )
342: IS
343: SELECT version_number
344: FROM igs_en_stdnt_ps_att

Line 344: FROM igs_en_stdnt_ps_att

340: cp_course_cd igs_en_stdnt_ps_att.course_cd%TYPE
341: )
342: IS
343: SELECT version_number
344: FROM igs_en_stdnt_ps_att
345: WHERE person_id = cp_person_id AND course_cd = cp_course_cd;
346:
347: l_course_version_number igs_en_stdnt_ps_att.version_number%TYPE;
348:

Line 347: l_course_version_number igs_en_stdnt_ps_att.version_number%TYPE;

343: SELECT version_number
344: FROM igs_en_stdnt_ps_att
345: WHERE person_id = cp_person_id AND course_cd = cp_course_cd;
346:
347: l_course_version_number igs_en_stdnt_ps_att.version_number%TYPE;
348:
349: -- CURSOR to get the total unit level
350: CURSOR c_total_unt_lvl_cp (
351: cp_unit_level igs_pr_ul_mark_cnfg.unit_level%TYPE,