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_FI_PRC_DISC_SUA dependencies on IGS_EN_SU_ATTEMPT

Line 443: CURSOR cur_enrl_dt(cp_person_id IN igs_en_su_attempt.person_id%TYPE,

439:
440: -- Enh # 2187247
441: -- Modified the cursor for fetching the unit attempt status
442: -- Cursor for fetching the Enrolment details
443: CURSOR cur_enrl_dt(cp_person_id IN igs_en_su_attempt.person_id%TYPE,
444: cp_course_cd IN igs_en_su_attempt.course_cd%TYPE,
445: cp_uoo_id IN igs_en_su_attempt.uoo_id%TYPE) IS
446: SELECT enrolled_dt,
447: unit_cd,

Line 444: cp_course_cd IN igs_en_su_attempt.course_cd%TYPE,

440: -- Enh # 2187247
441: -- Modified the cursor for fetching the unit attempt status
442: -- Cursor for fetching the Enrolment details
443: CURSOR cur_enrl_dt(cp_person_id IN igs_en_su_attempt.person_id%TYPE,
444: cp_course_cd IN igs_en_su_attempt.course_cd%TYPE,
445: cp_uoo_id IN igs_en_su_attempt.uoo_id%TYPE) IS
446: SELECT enrolled_dt,
447: unit_cd,
448: version_number,

Line 445: cp_uoo_id IN igs_en_su_attempt.uoo_id%TYPE) IS

441: -- Modified the cursor for fetching the unit attempt status
442: -- Cursor for fetching the Enrolment details
443: CURSOR cur_enrl_dt(cp_person_id IN igs_en_su_attempt.person_id%TYPE,
444: cp_course_cd IN igs_en_su_attempt.course_cd%TYPE,
445: cp_uoo_id IN igs_en_su_attempt.uoo_id%TYPE) IS
446: SELECT enrolled_dt,
447: unit_cd,
448: version_number,
449: cal_type,

Line 455: FROM igs_en_su_attempt

451: location_cd,
452: unit_class,
453: uoo_id,
454: unit_attempt_status
455: FROM igs_en_su_attempt
456: WHERE person_id = cp_person_id
457: AND course_cd = cp_course_cd
458: AND uoo_id = cp_uoo_id;
459:

Line 494: l_enrolled_dt igs_en_su_attempt.enrolled_dt%TYPE;

490: l_fee_ci_sequence_number igs_fi_inv_int.fee_ci_sequence_number%TYPE;
491: l_ld_cal_type igs_ca_inst.cal_type%TYPE;
492: l_ld_ci_sequence_number Igs_ca_inst.sequence_number%TYPE;
493: l_person_number igs_pe_person.person_number%TYPE;
494: l_enrolled_dt igs_en_su_attempt.enrolled_dt%TYPE;
495: l_person_name igs_pe_person.full_name%TYPE;
496: l_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE;
497: l_last_conversion_date igs_fi_balance_rules.last_conversion_date%TYPE;
498: l_version_number igs_fi_balance_rules.version_number%TYPE;