APPS.JA_CN_FA_ADI_EXPORT_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 89: fa_distribution_history fdh,

85: fa_transaction_headers fth,
86: fa_additions fa,
87: fa_books fb,
88: fa_book_controls_sec fbcs,
89: fa_distribution_history fdh,
90: fa_deprn_periods fdp
91: --gl_code_combinations gcc
92: WHERE (fth.transaction_type_code = 'FULL RETIREMENT' OR
93: fth.transaction_type_code = 'PARTIAL RETIREMENT')

Line 260: FROM fa_distribution_history fdh

256: fdp.calendar_period_open_date) <= v_row.transaction_date;
257: --get the total unit at the transaction time
258: SELECT SUM(fdh.units_assigned)
259: INTO ln_total_unit
260: FROM fa_distribution_history fdh
261: WHERE fdh.asset_id = v_row.asset_id
262: AND fdh.date_effective < nvl(ld_dp_close_date, SYSDATE)
263: AND (fdh.date_ineffective > nvl(ld_dp_close_date, SYSDATE) OR
264: fdh.date_ineffective IS NULL);

Line 268: FROM fa_distribution_history fdh

264: fdh.date_ineffective IS NULL);
265: --get the assigned unit at the transaction time
266: SELECT SUM(fdh.units_assigned)
267: INTO ln_assigned_unit
268: FROM fa_distribution_history fdh
269: WHERE fdh.asset_id = v_row.asset_id
270: AND fdh.date_effective < nvl(ld_dp_close_date, SYSDATE)
271: AND (fdh.date_ineffective > nvl(ld_dp_close_date, SYSDATE) OR
272: fdh.date_ineffective IS NULL)