APPS.IGI_IAC_REVAL_CRUD dependencies on FA_DEPRN_DETAIL

Line 1152: from fa_deprn_detail

1148:
1149: cursor c_get_dist_deprn(cp_distribution_id number) is
1150: select (nvl(deprn_amount,0) - nvl(deprn_adjustment_amount,0)) deprn_amount,
1151: deprn_reserve
1152: from fa_deprn_detail
1153: where book_type_code = fp_reval_params.reval_asset_params.book_type_code
1154: and asset_id = fp_reval_params.reval_asset_params.asset_id
1155: and distribution_id = cp_distribution_id
1156: and period_counter = (select max(period_counter)

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

1157: from fa_deprn_summary
1158: where book_type_code = fp_reval_params.reval_asset_params.book_type_code
1159: and asset_id = fp_reval_params.reval_asset_params.asset_id);
1160:
1161: cursor c_get_dist_ytd(cp_distribution_id fa_deprn_detail.distribution_id%TYPE) is
1162: select sum(nvl(fdd.deprn_amount,0)-nvl(fdd.deprn_adjustment_amount,0)) deprn_YTD
1163: from fa_deprn_detail fdd
1164: where fdd.book_type_code = fp_reval_params.reval_asset_params.book_type_code
1165: and fdd.asset_id = fp_reval_params.reval_asset_params.asset_id

Line 1163: from fa_deprn_detail fdd

1159: and asset_id = fp_reval_params.reval_asset_params.asset_id);
1160:
1161: cursor c_get_dist_ytd(cp_distribution_id fa_deprn_detail.distribution_id%TYPE) is
1162: select sum(nvl(fdd.deprn_amount,0)-nvl(fdd.deprn_adjustment_amount,0)) deprn_YTD
1163: from fa_deprn_detail fdd
1164: where fdd.book_type_code = fp_reval_params.reval_asset_params.book_type_code
1165: and fdd.asset_id = fp_reval_params.reval_asset_params.asset_id
1166: and fdd.distribution_id = cp_distribution_id
1167: and fdd.period_counter in (select period_counter from fa_deprn_periods