DBA Data[Home] [Help]

APPS.FA_INS_ADJUST_PKG dependencies on FA_DEPRN_DETAIL_MRC_V

Line 1035: from fa_deprn_detail_mrc_v

1031: if(h_period_of_addition = 'Y') then---Need to add MRC tables.
1032: if(H_DPR_ROW.mrc_sob_type_code = 'R') then
1033: select count(*)
1034: into h_dd_count
1035: from fa_deprn_detail_mrc_v
1036: where asset_id = adj_ptr.asset_id
1037: and book_type_code = adj_ptr.book_type_code
1038: and deprn_source_code = 'D';
1039: if(h_dd_count = 0)then

Line 1042: from fa_deprn_detail_mrc_v

1038: and deprn_source_code = 'D';
1039: if(h_dd_count = 0)then
1040: select addition_cost_to_clear--, nvl(deprn_reserve,0)
1041: into h_dpr_row.cost--, h_dpr_row.deprn_rsv
1042: from fa_deprn_detail_mrc_v
1043: where asset_id = adj_ptr.asset_id
1044: and book_type_code = adj_ptr.book_type_code
1045: and deprn_source_code = 'B'
1046: and distribution_id = h_distribution_id;