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
' 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: