APPS.IGS_PS_GEN_006 dependencies on IGS_PS_UNIT_TYPE_LVL

Line 1141: v_level_code IGS_PS_UNIT_TYPE_LVL.LEVEL_CODE%TYPE;

1137: lv_param_values VARCHAR2(1080);
1138: v_ul_description IGS_PS_UNIT_LEVEL.description%TYPE;
1139: v_ou_description IGS_OR_UNIT.description%TYPE;
1140: v_uicl_description IGS_PS_UNIT_INT_LVL.description%TYPE;
1141: v_level_code IGS_PS_UNIT_TYPE_LVL.LEVEL_CODE%TYPE;
1142: v_repeat_code IGS_PS_RPT_FMLY_ALL.REPEAT_CODE%TYPE;
1143: v_subtitle IGS_PS_UNIT_SUBTITLE.SUBTITLE%TYPE;
1144:
1145: CURSOR c_unit_level(

Line 1164: CURSOR c_unit_type_level ( cp_unit_type_id IGS_PS_UNIT_TYPE_LVL.UNIT_TYPE_ID%TYPE ) IS

1160: SELECT description
1161: FROM IGS_PS_UNIT_INT_LVL
1162: WHERE unit_int_course_level_cd = cp_unit_int_course_level_cd;
1163:
1164: CURSOR c_unit_type_level ( cp_unit_type_id IGS_PS_UNIT_TYPE_LVL.UNIT_TYPE_ID%TYPE ) IS
1165: SELECT level_code
1166: FROM IGS_PS_UNIT_TYPE_LVL
1167: WHERE UNIT_TYPE_ID = cp_unit_type_id;
1168:

Line 1166: FROM IGS_PS_UNIT_TYPE_LVL

1162: WHERE unit_int_course_level_cd = cp_unit_int_course_level_cd;
1163:
1164: CURSOR c_unit_type_level ( cp_unit_type_id IGS_PS_UNIT_TYPE_LVL.UNIT_TYPE_ID%TYPE ) IS
1165: SELECT level_code
1166: FROM IGS_PS_UNIT_TYPE_LVL
1167: WHERE UNIT_TYPE_ID = cp_unit_type_id;
1168:
1169: CURSOR c_repeat_family ( cp_rpt_fmly_id IGS_PS_RPT_FMLY_ALL.RPT_FMLY_ID%TYPE ) IS
1170: SELECT repeat_code