APPS.IGS_AV_VAL_ASULEB dependencies on IGS_AV_STND_UNIT_LVL_ALL
Line 325: FROM igs_av_stnd_unit_lvl_all
321: AND exemption_institution_cd = cp_exemption_institution_cd
322: AND unit_details_id IS NOT NULL
323: UNION ALL
324: SELECT DISTINCT unit_details_id 325: FROM igs_av_stnd_unit_lvl_all 326: WHERE person_id = cp_person_id
327: AND exemption_institution_cd = cp_exemption_institution_cd
328: AND unit_details_id IS NOT NULL) rslt;
329: rec_chk_adv cur_chk_adv%ROWTYPE;
' new_grade,
378: 'UNIT LEVEL' lvl,
379: avl.av_stnd_unit_lvl_id pk 380: FROM igs_av_stnd_unit_lvl_all avl, 381: igs_ad_term_unitdtls atu1
382: WHERE avl.person_id = cp_person_id
383: AND avl.unit_details_id = cp_unit_details_id
384: AND atu1.unit_details_id = avl.unit_details_id;
Line 399: FROM igs_av_stnd_unit_lvl_all unl_lvl
395: --Select Advanced Standing Unit Level records for updation of unit_details_id.
396: CURSOR cur_get_adv_unit_lvl_dtls(cp_av_stnd_unit_lvl_id NUMBER) IS
397: SELECT unl_lvl.rowid,
398: unl_lvl.* 399: FROM igs_av_stnd_unit_lvl_all unl_lvl 400: WHERE unl_lvl.av_stnd_unit_lvl_id = cp_av_stnd_unit_lvl_id
401: FOR UPDATE OF unit_details_id;
402: rec_get_adv_unit_lvl_dtls cur_get_adv_unit_lvl_dtls%ROWTYPE;
403: