APPS.IGS_FI_PRC_SP_FEES dependencies on IGS_LOOKUPS_VIEW

Line 323: cp_v_unit_att_status igs_lookups_view.lookup_type%TYPE,

319: -- Cursor to determine if the current unit attempt is assessable or not
320: CURSOR cur_unit_load(cp_n_person_id hz_parties.party_id%TYPE,
321: cp_v_course_cd igs_ps_ver.course_cd%TYPE,
322: cp_n_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
323: cp_v_unit_att_status igs_lookups_view.lookup_type%TYPE,
324: cp_v_fee_ass_ind igs_lookups_view.fee_ass_ind%TYPE) IS
325: SELECT sua.cal_type,
326: sua.ci_sequence_number, sua.discontinued_dt,
327: sua.administrative_unit_status, sua.unit_attempt_status,

Line 324: cp_v_fee_ass_ind igs_lookups_view.fee_ass_ind%TYPE) IS

320: CURSOR cur_unit_load(cp_n_person_id hz_parties.party_id%TYPE,
321: cp_v_course_cd igs_ps_ver.course_cd%TYPE,
322: cp_n_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE,
323: cp_v_unit_att_status igs_lookups_view.lookup_type%TYPE,
324: cp_v_fee_ass_ind igs_lookups_view.fee_ass_ind%TYPE) IS
325: SELECT sua.cal_type,
326: sua.ci_sequence_number, sua.discontinued_dt,
327: sua.administrative_unit_status, sua.unit_attempt_status,
328: sua.no_assessment_ind

Line 330: igs_lookups_view lkp

326: sua.ci_sequence_number, sua.discontinued_dt,
327: sua.administrative_unit_status, sua.unit_attempt_status,
328: sua.no_assessment_ind
329: FROM igs_en_su_attempt sua,
330: igs_lookups_view lkp
331: WHERE sua.person_id = cp_n_person_id
332: AND sua.course_cd = cp_v_course_cd
333: AND sua.uoo_id = cp_n_uoo_id
334: AND lkp.lookup_type = cp_v_unit_att_status