APPS.JA_CN_FA_MI_EXPORT_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 95: fa_distribution_history fdh,

91: FROM fa_transaction_headers fth,
92: fa_additions fa,
93: fa_books fb,
94: fa_book_controls_sec fbcs,
95: fa_distribution_history fdh,
96: fa_deprn_periods fdp
97: --gl_code_combinations gcc
98: WHERE fth.transaction_type_code IN
99: ('ADDITION', 'ADJUSTMENT', 'RECLASS', 'REINSTATEMENT',

Line 221: FROM fa_distribution_history fdh

217: fdp.calendar_period_open_date) <= v_row.transaction_date;
218: --get the total unit at the transaction time
219: SELECT SUM(fdh.units_assigned)
220: INTO ln_total_unit
221: FROM fa_distribution_history fdh
222: WHERE fdh.asset_id = v_row.asset_id
223: AND fdh.date_effective < nvl(ld_dp_close_date, SYSDATE)
224: AND (fdh.date_ineffective > nvl(ld_dp_close_date, SYSDATE) OR
225: fdh.date_ineffective IS NULL);

Line 229: FROM fa_distribution_history fdh

225: fdh.date_ineffective IS NULL);
226: --get the assigned unit at the transaction time
227: SELECT SUM(fdh.units_assigned)
228: INTO ln_assigned_unit
229: FROM fa_distribution_history fdh
230: WHERE fdh.asset_id = v_row.asset_id
231: AND fdh.date_effective < nvl(ld_dp_close_date, SYSDATE)
232: AND (fdh.date_ineffective > nvl(ld_dp_close_date, SYSDATE) OR
233: fdh.date_ineffective IS NULL)

Line 296: FROM fa_distribution_history fdh

292: THEN
293: --get the total unit at the transaction time, before the unit adjustment
294: SELECT SUM(fdh.units_assigned)
295: INTO ln_total_unit_before
296: FROM fa_distribution_history fdh
297: WHERE fdh.asset_id = v_row.asset_id
298: AND fdh.transaction_header_id_in < v_row.transaction_header_id
299: AND fdh.date_effective < nvl(ld_dp_close_date, SYSDATE)
300: AND (fdh.date_ineffective > nvl(ld_dp_close_date, SYSDATE) OR

Line 305: FROM fa_distribution_history fdh

301: fdh.date_ineffective IS NULL);
302: --get the assigned unit at the transaction time, before the unit adjustment
303: SELECT SUM(fdh.units_assigned)
304: INTO ln_assigned_unit_before
305: FROM fa_distribution_history fdh
306: WHERE fdh.asset_id = v_row.asset_id
307: AND fdh.transaction_header_id_in < v_row.transaction_header_id
308: AND fdh.date_effective < nvl(ld_dp_close_date, SYSDATE)
309: AND (fdh.date_ineffective > nvl(ld_dp_close_date, SYSDATE) OR