200: p_mrcsobtype := 'P';
201: END IF;
202: IF upper(p_mrcsobtype) = 'R'
203: THEN
204: lp_fa_deprn_summary := 'FA_DEPRN_SUMMARY_MRC_V';
205: ELSE
206: lp_fa_deprn_summary := 'FA_DEPRN_SUMMARY';
207: END IF;
208: return (TRUE);
982: 'G' T_TYPE,
983: DD.PERIOD_COUNTER,
984: UCD
985: FROM
986: FA_DEPRN_SUMMARY_MRC_V DD,
987: FA_GROUP_ASSET_RULES GAR,
988: FA_GROUP_ASSET_DEFAULT GAD,
989: FA_DEPRN_PERIODS_MRC_V DP
990: WHERE
1117: 100 PERCENT,
1118: 'G' T_TYPE,
1119: DD.PERIOD_COUNTER,
1120: UCD
1121: FROM FA_DEPRN_SUMMARY_MRC_V DD,
1122: fa_GROUP_ASSET_RULES GAR,
1123: fa_GROUP_ASSET_DEFAULT GAD,
1124: fa_SUPER_GROUP_RULES SGR,
1125: FA_DEPRN_PERIODS_MRC_V DP