480: FROM igs_av_stnd_unit_all unt
481: WHERE p_person_id = unt.person_id
482: FOR UPDATE NOWAIT;
483:
484: CURSOR c_adv_unt_basis(cp_AV_STND_UNIT_ID IGS_AV_STD_UNT_BASIS_ALL.AV_STND_UNIT_ID%type)
485: IS
486: SELECT unt.ROWID, unt.*
487: FROM IGS_AV_STD_UNT_BASIS_ALL unt
488: WHERE unt.AV_STND_UNIT_ID = cp_AV_STND_UNIT_ID
483:
484: CURSOR c_adv_unt_basis(cp_AV_STND_UNIT_ID IGS_AV_STD_UNT_BASIS_ALL.AV_STND_UNIT_ID%type)
485: IS
486: SELECT unt.ROWID, unt.*
487: FROM IGS_AV_STD_UNT_BASIS_ALL unt
488: WHERE unt.AV_STND_UNIT_ID = cp_AV_STND_UNIT_ID
489: FOR UPDATE NOWAIT;
490:
491: BEGIN