APPS.IGS_AV_VAL_ASULEB dependencies on IGS_AV_STND_ALT_UNIT

Line 415: FROM igs_av_stnd_alt_unit alt

411:
412: --Cursor to fetch the Alt Unit Details for the Unit Advanced Standing.
413: CURSOR cur_get_alt_unit(cp_av_stnd_unit_id NUMBER) IS
414: SELECT alt.rowid
415: FROM igs_av_stnd_alt_unit alt
416: WHERE alt.av_stnd_unit_id = cp_av_stnd_unit_id;
417: rec_get_alt_unit cur_get_alt_unit%ROWTYPE;
418:
419: --Cursor to fetch the Basis Details for the Unit Advanced Standing.

Line 554: igs_av_stnd_alt_unit_pkg.delete_row(X_ROWID => rec_get_alt_unit.rowid);

550: --/*
551: IF RTRIM(rec_del_adv_dtls.lvl) = 'UNIT' AND SUBSTR(rec_del_adv_dtls.ece_type, 20, 10) = 'PRECLUSION' THEN
552: --Check if there exists any Alternate Unit Details; If exists then delete it;
553: FOR rec_get_alt_unit IN cur_get_alt_unit(rec_del_adv_dtls.pk) LOOP
554: igs_av_stnd_alt_unit_pkg.delete_row(X_ROWID => rec_get_alt_unit.rowid);
555: END LOOP;
556:
557: --Check if there exists any Unit Basis Details; If exists then delete it;
558: FOR rec_get_bas_dtl IN cur_get_bas_dtl(rec_del_adv_dtls.pk) LOOP