APPS.FA_INS_ADJUST_PKG dependencies on FA_DEPRN_DETAIL

Line 221: -- FA_DEPRN_DETAIL, then figure out the detail_amount;

217: h_adj_dd_amount number;
218:
219: BEGIN <>
220: -- If the account type is an amount that we track in
221: -- FA_DEPRN_DETAIL, then figure out the detail_amount;
222: -- For those account types that we do not track
223: -- (ie DEPRN_EXPENSE), the detail amount is
224: -- set to zero.
225: if (not adj_ptr.leveling_flag) then

Line 976: -- Get the FA_DEPRN_DETAIL value for the PERIOD_ADJUSTED,

972: h_dist_ccid := distribution.code_combination_id;
973: h_units_assigned := distribution.units_assigned;
974: h_row_ctr := h_row_ctr+1;
975:
976: -- Get the FA_DEPRN_DETAIL value for the PERIOD_ADJUSTED,
977: -- plus/minus any adjustments by calling Query Fin Info
978: -- in detail mode:
979: H_DPR_ROW.asset_id:=adj_ptr.asset_id;
980: H_DPR_ROW.book:=adj_ptr.book_type_code;

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;

Line 1052: from fa_deprn_detail

1048:
1049: else
1050: select count(*)
1051: into h_dd_count
1052: from fa_deprn_detail
1053: where asset_id = adj_ptr.asset_id
1054: and book_type_code = adj_ptr.book_type_code
1055: and deprn_source_code = 'D';
1056: if(h_dd_count = 0)then

Line 1059: from fa_deprn_detail

1055: and deprn_source_code = 'D';
1056: if(h_dd_count = 0)then
1057: select addition_cost_to_clear--, nvl(deprn_reserve,0)
1058: into h_dpr_row.cost--, h_dpr_row.deprn_rsv
1059: from fa_deprn_detail
1060: where asset_id = adj_ptr.asset_id
1061: and book_type_code = adj_ptr.book_type_code
1062: and deprn_source_code = 'B'
1063: and distribution_id = h_distribution_id;

Line 1853: -- Get the FA_DEPRN_DETAIL value for the period_adjusted, plus/minus

1849: H_DPR_ROW.period_ctr:= 0;
1850: H_DPR_ROW.mrc_sob_type_code := h_mrc_sob_type_code;
1851: H_DPR_ROW.set_of_books_id := h_set_of_books_id;
1852:
1853: -- Get the FA_DEPRN_DETAIL value for the period_adjusted, plus/minus
1854: -- any adjustments by calling Query Fin Info in detail mode
1855: FA_QUERY_BALANCES_PKG.QUERY_BALANCES_INT(H_DPR_ROW,
1856: 'STANDARD',
1857: FALSE,