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.

[Home] [Help]

APPS.IGS_FI_PRC_SP_FEES dependencies on IGS_EN_SU_ATTEMPT_ALL

Line 129: CURSOR c_org_unit_cd(cp_person_id IN igs_en_su_attempt_all.person_id%TYPE,

125: FROM igs_fi_fee_type
126: WHERE fee_type = cp_v_fee_type;
127:
128: --Cursor to select the org unit cd and location cd from igs_en_su_attempt
129: CURSOR c_org_unit_cd(cp_person_id IN igs_en_su_attempt_all.person_id%TYPE,
130: cp_course_cd in igs_en_su_attempt_all.course_cd%TYPE,
131: cp_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE
132: ) IS
133: SELECT org_unit_cd ,location_cd

Line 130: cp_course_cd in igs_en_su_attempt_all.course_cd%TYPE,

126: WHERE fee_type = cp_v_fee_type;
127:
128: --Cursor to select the org unit cd and location cd from igs_en_su_attempt
129: CURSOR c_org_unit_cd(cp_person_id IN igs_en_su_attempt_all.person_id%TYPE,
130: cp_course_cd in igs_en_su_attempt_all.course_cd%TYPE,
131: cp_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE
132: ) IS
133: SELECT org_unit_cd ,location_cd
134: FROM igs_en_su_attempt su

Line 131: cp_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE

127:
128: --Cursor to select the org unit cd and location cd from igs_en_su_attempt
129: CURSOR c_org_unit_cd(cp_person_id IN igs_en_su_attempt_all.person_id%TYPE,
130: cp_course_cd in igs_en_su_attempt_all.course_cd%TYPE,
131: cp_uoo_id IN igs_en_su_attempt_all.uoo_id%TYPE
132: ) IS
133: SELECT org_unit_cd ,location_cd
134: FROM igs_en_su_attempt su
135: WHERE su.person_id = cp_person_id

Line 171: l_v_derived_org_unit_cd igs_en_su_attempt_all.org_unit_cd%TYPE;

167: l_v_msg_data VARCHAR2(4000) := NULL;
168:
169: --local parameters to hold the org unit code and loaction code values from the cursor.
170: l_rec_cur_org_unit_cd c_org_unit_cd%ROWTYPE;
171: l_v_derived_org_unit_cd igs_en_su_attempt_all.org_unit_cd%TYPE;
172: --CUROSR
173: l_c_unit_level_detail c_unit_level_detail%ROWTYPE;
174:
175: l_n_waiver_amount NUMBER;

Line 341: cp_v_course_cd igs_en_su_attempt_all.course_cd%TYPE) IS

337:
338: -- Cursor to determine the SUA status
339: CURSOR cur_sua_status(cp_n_person_id igs_en_su_attempt.person_id%TYPE,
340: cp_n_uoo_id igs_en_su_attempt.uoo_id%TYPE,
341: cp_v_course_cd igs_en_su_attempt_all.course_cd%TYPE) IS
342: SELECT sua.unit_attempt_status,
343: sua.discontinued_dt,
344: sua.dcnt_reason_cd
345: FROM igs_en_su_attempt sua