[Home] [Help]
51:
52: FUNCTION GET_INQ_PROG_UNIT_SETS(x_prog_pref_id IN NUMBER) RETURN VARCHAR2 IS
53: CURSOR cur_unit_sets IS
54: SELECT CODE.DESCRIPTION
55: FROM IGS_AD_I_PRG_PRF_UST PREF,
56: IGS_AD_I_PRG_U_SET USET,
57: IGS_AD_INQ_UNIT_SETS CODE
58: WHERE PREF.INQ_PROG_UNIT_SET_ID = USET.INQ_PROG_UNIT_SET_ID
59: AND USET.INQ_UNIT_SET_CODE_ID = CODE.INQ_UNIT_SET_CODE_ID