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;

Line 380: FROM igs_av_stnd_unit_lvl_all avl,

376: ''||(RPAD(NVL(TO_CHAR(atu1.cp_earned), nbsp), 7))||'' new_cp_earned,
377: ''||(RPAD(NVL(atu1.grade, nbsp), 10))||'' 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: