APPS.IGS_PS_GEN_006 dependencies on IGS_PS_UNIT_INT_LVL

Line 1140: v_uicl_description IGS_PS_UNIT_INT_LVL.description%TYPE;

1136: AS
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:

Line 1159: IGS_PS_UNIT_INT_LVL.unit_int_course_level_cd%TYPE) IS

1155: WHERE party_number = cp_org_unit_cd AND
1156: start_dt = cp_start_dt;
1157: CURSOR c_unit_int_course_level(
1158: cp_unit_int_course_level_cd
1159: IGS_PS_UNIT_INT_LVL.unit_int_course_level_cd%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:

Line 1161: FROM IGS_PS_UNIT_INT_LVL

1157: CURSOR c_unit_int_course_level(
1158: cp_unit_int_course_level_cd
1159: IGS_PS_UNIT_INT_LVL.unit_int_course_level_cd%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