APPS.IGS_PS_GEN_006 dependencies on IGS_PS_RPT_FMLY_ALL

Line 1142: v_repeat_code IGS_PS_RPT_FMLY_ALL.REPEAT_CODE%TYPE;

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(
1146: cp_unit_level IGS_PS_UNIT_LEVEL.unit_level%TYPE) IS

Line 1169: CURSOR c_repeat_family ( cp_rpt_fmly_id IGS_PS_RPT_FMLY_ALL.RPT_FMLY_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
1171: FROM IGS_PS_RPT_FMLY_ALL
1172: WHERE RPT_FMLY_ID= cp_rpt_fmly_id;
1173:

Line 1171: FROM IGS_PS_RPT_FMLY_ALL

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
1171: FROM IGS_PS_RPT_FMLY_ALL
1172: WHERE RPT_FMLY_ID= cp_rpt_fmly_id;
1173:
1174: CURSOR c_unit_subtitle ( cp_subtitle_id IGS_PS_UNIT_SUBTITLE.SUBTITLE_ID%TYPE ) IS
1175: SELECT subtitle