APPS.IGS_PS_GEN_006 dependencies on IGS_PS_UNIT_LEVEL

Line 1138: v_ul_description IGS_PS_UNIT_LEVEL.description%TYPE;

1134: p_workload_val_code IN VARCHAR2,
1135: p_billing_hrs IN NUMBER )
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;

Line 1146: cp_unit_level IGS_PS_UNIT_LEVEL.unit_level%TYPE) IS

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(
1146: cp_unit_level IGS_PS_UNIT_LEVEL.unit_level%TYPE) IS
1147: SELECT description
1148: FROM IGS_PS_UNIT_LEVEL
1149: WHERE unit_level = cp_unit_level;
1150: CURSOR c_org_unit(

Line 1148: FROM IGS_PS_UNIT_LEVEL

1144:
1145: CURSOR c_unit_level(
1146: cp_unit_level IGS_PS_UNIT_LEVEL.unit_level%TYPE) IS
1147: SELECT description
1148: FROM IGS_PS_UNIT_LEVEL
1149: WHERE unit_level = cp_unit_level;
1150: CURSOR c_org_unit(
1151: cp_org_unit_cd IGS_OR_UNIT.org_unit_cd%TYPE,
1152: cp_start_dt IGS_OR_UNIT.start_dt%TYPE) IS