APPS.IGS_AV_VAL_ASULEB dependencies on IGS_AV_STND_UNIT_ALL

Line 319: FROM igs_av_stnd_unit_all

315: --Cursor to get the Advanced Standing records for Student.
316: CURSOR cur_chk_adv(cp_person_id NUMBER, cp_exemption_institution_cd VARCHAR2) IS
317: SELECT DISTINCT rslt.unit_details_id FROM (
318: SELECT DISTINCT unit_details_id
319: FROM igs_av_stnd_unit_all
320: WHERE person_id = cp_person_id
321: AND exemption_institution_cd = cp_exemption_institution_cd
322: AND unit_details_id IS NOT NULL
323: UNION ALL

Line 362: FROM igs_av_stnd_unit_all av,

358: ''||(RPAD(NVL(TO_CHAR(atu.cp_earned), nbsp), 7))||'' new_cp_earned,
359: ''||(RPAD(NVL(atu.grade, nbsp), 10))||'' new_grade,
360: 'UNIT' lvl,
361: av.av_stnd_unit_id pk
362: FROM igs_av_stnd_unit_all av,
363: igs_ad_term_unitdtls atu
364: WHERE av.person_id = cp_person_id
365: AND av.unit_details_id = cp_unit_details_id
366: AND atu.unit_details_id = av.unit_details_id

Line 390: FROM igs_av_stnd_unit_all unit

386: --Select Advanced Standing Unit records for updation of unit_details_id.
387: CURSOR cur_get_adv_unit_dtls(cp_av_stnd_unit_id NUMBER) IS
388: SELECT unit.rowid,
389: unit.*
390: FROM igs_av_stnd_unit_all unit
391: WHERE unit.av_stnd_unit_id = cp_av_stnd_unit_id
392: FOR UPDATE OF unit_details_id;
393: rec_get_adv_unit_dtls cur_get_adv_unit_dtls%ROWTYPE;
394: