eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_GEN_007 dependencies on IGS_EN_SU_ATTEMPT

Line 67: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,

63: END enrp_get_student_ind;
64:
65: FUNCTION Enrp_Get_Suah_Col(
66: p_column_name IN user_tab_columns.column_name%TYPE ,
67: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
68: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
69: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
70: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
71: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,

Line 68: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,

64:
65: FUNCTION Enrp_Get_Suah_Col(
66: p_column_name IN user_tab_columns.column_name%TYPE ,
67: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
68: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
69: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
70: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
71: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
72: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,

Line 69: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,

65: FUNCTION Enrp_Get_Suah_Col(
66: p_column_name IN user_tab_columns.column_name%TYPE ,
67: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
68: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
69: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
70: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
71: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
72: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,
73: p_uoo_id IN IGS_EN_SU_ATTEMPT_H_ALL.UOO_ID%TYPE)

Line 70: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,

66: p_column_name IN user_tab_columns.column_name%TYPE ,
67: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
68: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
69: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
70: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
71: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
72: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,
73: p_uoo_id IN IGS_EN_SU_ATTEMPT_H_ALL.UOO_ID%TYPE)
74: -------------------------------------------------------------------------------------------

Line 71: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,

67: p_person_id IN IGS_EN_SU_ATTEMPT_H_ALL.person_id%TYPE ,
68: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
69: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
70: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
71: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
72: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,
73: p_uoo_id IN IGS_EN_SU_ATTEMPT_H_ALL.UOO_ID%TYPE)
74: -------------------------------------------------------------------------------------------
75: --Change History:

Line 72: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,

68: p_course_cd IN IGS_EN_SU_ATTEMPT_H_ALL.course_cd%TYPE ,
69: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
70: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
71: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
72: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,
73: p_uoo_id IN IGS_EN_SU_ATTEMPT_H_ALL.UOO_ID%TYPE)
74: -------------------------------------------------------------------------------------------
75: --Change History:
76: --Who When What

Line 73: p_uoo_id IN IGS_EN_SU_ATTEMPT_H_ALL.UOO_ID%TYPE)

69: p_unit_cd IN IGS_EN_SU_ATTEMPT_H_ALL.unit_cd%TYPE ,
70: p_cal_type IN IGS_EN_SU_ATTEMPT_H_ALL.cal_type%TYPE ,
71: p_ci_sequence_number IN IGS_EN_SU_ATTEMPT_H_ALL.ci_sequence_number%TYPE ,
72: p_hist_end_dt IN IGS_EN_SU_ATTEMPT_H_ALL.hist_end_dt%TYPE,
73: p_uoo_id IN IGS_EN_SU_ATTEMPT_H_ALL.UOO_ID%TYPE)
74: -------------------------------------------------------------------------------------------
75: --Change History:
76: --Who When What
77: --kkillams 25-04-2003 New paramater p_uoo_id is added to the function and c_suah cursor modified.

Line 86: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,

82: BEGIN
83: DECLARE
84: CURSOR c_suah(
85: cp_column_name user_tab_columns.column_name%TYPE,
86: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
87: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
88: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE,
89: cp_hist_end_dt IGS_EN_SU_ATTEMPT_H.hist_end_dt%TYPE) IS
90: SELECT DECODE ( cp_column_name,

Line 87: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,

83: DECLARE
84: CURSOR c_suah(
85: cp_column_name user_tab_columns.column_name%TYPE,
86: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
87: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
88: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE,
89: cp_hist_end_dt IGS_EN_SU_ATTEMPT_H.hist_end_dt%TYPE) IS
90: SELECT DECODE ( cp_column_name,
91: 'VERSION_NUMBER', TO_CHAR(suah.version_number),

Line 88: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE,

84: CURSOR c_suah(
85: cp_column_name user_tab_columns.column_name%TYPE,
86: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
87: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
88: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE,
89: cp_hist_end_dt IGS_EN_SU_ATTEMPT_H.hist_end_dt%TYPE) IS
90: SELECT DECODE ( cp_column_name,
91: 'VERSION_NUMBER', TO_CHAR(suah.version_number),
92: 'LOCATION_CD', suah.location_cd,

Line 89: cp_hist_end_dt IGS_EN_SU_ATTEMPT_H.hist_end_dt%TYPE) IS

85: cp_column_name user_tab_columns.column_name%TYPE,
86: cp_person_id IGS_EN_SU_ATTEMPT_H.person_id%TYPE,
87: cp_course_cd IGS_EN_SU_ATTEMPT_H.course_cd%TYPE,
88: cp_uoo_id IGS_EN_SU_ATTEMPT_H.uoo_id%TYPE,
89: cp_hist_end_dt IGS_EN_SU_ATTEMPT_H.hist_end_dt%TYPE) IS
90: SELECT DECODE ( cp_column_name,
91: 'VERSION_NUMBER', TO_CHAR(suah.version_number),
92: 'LOCATION_CD', suah.location_cd,
93: 'UNIT_CLASS', suah.unit_class,

Line 109: FROM IGS_EN_SU_ATTEMPT_H suah

105: 'OVERRIDE_EFTSU', TO_CHAR(suah.override_eftsu),
106: 'OVERRIDE_ACHIEVABLE_CP', TO_CHAR(suah.override_achievable_cp),
107: 'OVERRIDE_OUTCOME_DUE_DT', igs_ge_date.igscharDT(suah.override_outcome_due_dt),
108: 'OVERRIDE_CREDIT_REASON', suah.override_credit_reason)
109: FROM IGS_EN_SU_ATTEMPT_H suah
110: WHERE suah.person_id = cp_person_id AND
111: suah.course_cd = cp_course_cd AND
112: suah.uoo_id = cp_uoo_id AND
113: suah.hist_start_dt >= cp_hist_end_dt

Line 221: FROM igs_en_su_attempt

217: -- igs_en_gen_008.enrp_get_uddc_aus function
218: CURSOR cur_sua
219: IS
220: SELECT no_assessment_ind
221: FROM igs_en_su_attempt
222: WHERE person_id = p_person_id
223: AND course_cd = p_course_cd
224: AND uoo_id = p_uoo_id;
225:

Line 302: cst_dropped CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DROPPED';

298:
299: BEGIN
300: DECLARE
301:
302: cst_dropped CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DROPPED';
303: cst_unconfirm CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'UNCONFIRM';
304: cst_waitlisted CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'WAITLISTED';
305: cst_discontin CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DISCONTIN';
306: cst_enrolled CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'ENROLLED';

Line 303: cst_unconfirm CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'UNCONFIRM';

299: BEGIN
300: DECLARE
301:
302: cst_dropped CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DROPPED';
303: cst_unconfirm CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'UNCONFIRM';
304: cst_waitlisted CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'WAITLISTED';
305: cst_discontin CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DISCONTIN';
306: cst_enrolled CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'ENROLLED';
307: cst_completed CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'COMPLETED';

Line 304: cst_waitlisted CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'WAITLISTED';

300: DECLARE
301:
302: cst_dropped CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DROPPED';
303: cst_unconfirm CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'UNCONFIRM';
304: cst_waitlisted CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'WAITLISTED';
305: cst_discontin CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DISCONTIN';
306: cst_enrolled CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'ENROLLED';
307: cst_completed CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'COMPLETED';
308: cst_invalid CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'INVALID';

Line 305: cst_discontin CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DISCONTIN';

301:
302: cst_dropped CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DROPPED';
303: cst_unconfirm CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'UNCONFIRM';
304: cst_waitlisted CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'WAITLISTED';
305: cst_discontin CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DISCONTIN';
306: cst_enrolled CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'ENROLLED';
307: cst_completed CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'COMPLETED';
308: cst_invalid CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'INVALID';
309: cst_duplicate CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DUPLICATE';

Line 306: cst_enrolled CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'ENROLLED';

302: cst_dropped CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DROPPED';
303: cst_unconfirm CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'UNCONFIRM';
304: cst_waitlisted CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'WAITLISTED';
305: cst_discontin CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DISCONTIN';
306: cst_enrolled CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'ENROLLED';
307: cst_completed CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'COMPLETED';
308: cst_invalid CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'INVALID';
309: cst_duplicate CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DUPLICATE';
310: cst_no CONSTANT IGS_AS_SU_STMPTOUT.finalised_outcome_ind%TYPE := 'N';

Line 307: cst_completed CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'COMPLETED';

303: cst_unconfirm CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'UNCONFIRM';
304: cst_waitlisted CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'WAITLISTED';
305: cst_discontin CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DISCONTIN';
306: cst_enrolled CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'ENROLLED';
307: cst_completed CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'COMPLETED';
308: cst_invalid CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'INVALID';
309: cst_duplicate CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DUPLICATE';
310: cst_no CONSTANT IGS_AS_SU_STMPTOUT.finalised_outcome_ind%TYPE := 'N';
311: cst_yes CONSTANT IGS_AS_SU_STMPTOUT.finalised_outcome_ind%TYPE := 'Y';

Line 308: cst_invalid CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'INVALID';

304: cst_waitlisted CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'WAITLISTED';
305: cst_discontin CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DISCONTIN';
306: cst_enrolled CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'ENROLLED';
307: cst_completed CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'COMPLETED';
308: cst_invalid CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'INVALID';
309: cst_duplicate CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DUPLICATE';
310: cst_no CONSTANT IGS_AS_SU_STMPTOUT.finalised_outcome_ind%TYPE := 'N';
311: cst_yes CONSTANT IGS_AS_SU_STMPTOUT.finalised_outcome_ind%TYPE := 'Y';
312: cst_grading_period_cd igs_as_su_stmptout.grading_period_cd%TYPE := 'FINAL';

Line 309: cst_duplicate CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DUPLICATE';

305: cst_discontin CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DISCONTIN';
306: cst_enrolled CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'ENROLLED';
307: cst_completed CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'COMPLETED';
308: cst_invalid CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'INVALID';
309: cst_duplicate CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'DUPLICATE';
310: cst_no CONSTANT IGS_AS_SU_STMPTOUT.finalised_outcome_ind%TYPE := 'N';
311: cst_yes CONSTANT IGS_AS_SU_STMPTOUT.finalised_outcome_ind%TYPE := 'Y';
312: cst_grading_period_cd igs_as_su_stmptout.grading_period_cd%TYPE := 'FINAL';
313: v_exists_flag VARCHAR2(1);

Line 314: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;

310: cst_no CONSTANT IGS_AS_SU_STMPTOUT.finalised_outcome_ind%TYPE := 'N';
311: cst_yes CONSTANT IGS_AS_SU_STMPTOUT.finalised_outcome_ind%TYPE := 'Y';
312: cst_grading_period_cd igs_as_su_stmptout.grading_period_cd%TYPE := 'FINAL';
313: v_exists_flag VARCHAR2(1);
314: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
315: v_enrolled_dt IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE;
316: v_rule_waived_dt IGS_EN_SU_ATTEMPT.rule_waived_dt%TYPE;
317: v_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE;
318:

Line 315: v_enrolled_dt IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE;

311: cst_yes CONSTANT IGS_AS_SU_STMPTOUT.finalised_outcome_ind%TYPE := 'Y';
312: cst_grading_period_cd igs_as_su_stmptout.grading_period_cd%TYPE := 'FINAL';
313: v_exists_flag VARCHAR2(1);
314: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
315: v_enrolled_dt IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE;
316: v_rule_waived_dt IGS_EN_SU_ATTEMPT.rule_waived_dt%TYPE;
317: v_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE;
318:
319: CURSOR c_get_db_param_values IS

Line 316: v_rule_waived_dt IGS_EN_SU_ATTEMPT.rule_waived_dt%TYPE;

312: cst_grading_period_cd igs_as_su_stmptout.grading_period_cd%TYPE := 'FINAL';
313: v_exists_flag VARCHAR2(1);
314: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
315: v_enrolled_dt IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE;
316: v_rule_waived_dt IGS_EN_SU_ATTEMPT.rule_waived_dt%TYPE;
317: v_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE;
318:
319: CURSOR c_get_db_param_values IS
320: SELECT unit_attempt_status,

Line 317: v_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE;

313: v_exists_flag VARCHAR2(1);
314: v_unit_attempt_status IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE;
315: v_enrolled_dt IGS_EN_SU_ATTEMPT.enrolled_dt%TYPE;
316: v_rule_waived_dt IGS_EN_SU_ATTEMPT.rule_waived_dt%TYPE;
317: v_discontinued_dt IGS_EN_SU_ATTEMPT.discontinued_dt%TYPE;
318:
319: CURSOR c_get_db_param_values IS
320: SELECT unit_attempt_status,
321: enrolled_dt,

Line 324: FROM IGS_EN_SU_ATTEMPT

320: SELECT unit_attempt_status,
321: enrolled_dt,
322: rule_waived_dt,
323: discontinued_dt
324: FROM IGS_EN_SU_ATTEMPT
325: WHERE person_id = p_person_id AND
326: course_cd = p_course_cd AND
327: uoo_id = p_uoo_id;
328: CURSOR c_chk_suao_exists IS

Line 343: FROM IGS_PS_STDNT_UNT_TRN sut1, IGS_EN_SU_ATTEMPT sua

339: grading_period_cd = cst_grading_period_cd
340: );
341: CURSOR c_sut IS
342: SELECT sua.unit_attempt_status
343: FROM IGS_PS_STDNT_UNT_TRN sut1, IGS_EN_SU_ATTEMPT sua
344: WHERE sut1.person_id = p_person_id AND
345: sut1.course_cd = p_course_cd AND
346: sua.person_id = sut1.person_id AND
347: sua.course_cd = sut1.transfer_course_cd AND