APPS.JA_CN_FA_MI_EXPORT_PKG dependencies on FA_DEPRN_PERIODS

Line 96: fa_deprn_periods fdp

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',
100: 'REVALUATION', 'TRANSFER', 'UNIT ADJUSTMENT',

Line 214: FROM fa_deprn_periods fdp

210: AND v_row.Transaction_Date BETWEEN gp.start_date AND
211: gp.end_date;
212: SELECT max(fdp.period_close_date)
213: INTO ld_dp_close_date
214: FROM fa_deprn_periods fdp
215: WHERE greatest(greatest(fdp.calendar_period_open_date,
216: least(SYSDATE, fdp.calendar_period_close_date)),
217: fdp.calendar_period_open_date) <= v_row.transaction_date;
218: --get the total unit at the transaction time

Line 573: fa_deprn_periods fdp

569: fds.impairment_reserve
570: INTO lv_before(1), lv_after(1)
571: FROM fa_deprn_summary fds,
572: fa_deprn_summary fds1,
573: fa_deprn_periods fdp
574: WHERE fds.asset_id = v_row.asset_id and fds1.asset_id = v_row.asset_id
575: AND fdp.book_type_code = v_row.book_type_code
576: AND fdp.book_type_code = fds.book_type_code
577: AND fdp.book_type_code = fds1.book_type_code