APPS.IGI_IAC_REVAL_CRUD dependencies on FA_DEPRN_DETAIL

Line 1136: from fa_deprn_detail

1132:
1133: cursor c_get_dist_deprn(cp_distribution_id number) is
1134: select (nvl(deprn_amount,0) - nvl(deprn_adjustment_amount,0)) deprn_amount,
1135: deprn_reserve
1136: from fa_deprn_detail
1137: where book_type_code = fp_reval_params.reval_asset_params.book_type_code
1138: and asset_id = fp_reval_params.reval_asset_params.asset_id
1139: and distribution_id = cp_distribution_id
1140: and period_counter = (select max(period_counter)

Line 1145: cursor c_get_dist_ytd(cp_distribution_id fa_deprn_detail.distribution_id%TYPE) is

1141: from fa_deprn_summary
1142: where book_type_code = fp_reval_params.reval_asset_params.book_type_code
1143: and asset_id = fp_reval_params.reval_asset_params.asset_id);
1144:
1145: cursor c_get_dist_ytd(cp_distribution_id fa_deprn_detail.distribution_id%TYPE) is
1146: select sum(nvl(fdd.deprn_amount,0)-nvl(fdd.deprn_adjustment_amount,0)) deprn_YTD
1147: from fa_deprn_detail fdd
1148: where fdd.book_type_code = fp_reval_params.reval_asset_params.book_type_code
1149: and fdd.asset_id = fp_reval_params.reval_asset_params.asset_id

Line 1147: from fa_deprn_detail fdd

1143: and asset_id = fp_reval_params.reval_asset_params.asset_id);
1144:
1145: cursor c_get_dist_ytd(cp_distribution_id fa_deprn_detail.distribution_id%TYPE) is
1146: select sum(nvl(fdd.deprn_amount,0)-nvl(fdd.deprn_adjustment_amount,0)) deprn_YTD
1147: from fa_deprn_detail fdd
1148: where fdd.book_type_code = fp_reval_params.reval_asset_params.book_type_code
1149: and fdd.asset_id = fp_reval_params.reval_asset_params.asset_id
1150: and fdd.distribution_id = cp_distribution_id
1151: and fdd.period_counter in (select period_counter from fa_deprn_periods