APPS.JA_CN_PS_FA_MI_EXP_PKG dependencies on FA_DEPRN_PERIODS

Line 108: , fa_deprn_periods fdp

104: , fa_additions fa
105: , fa_books fb
106: , fa_book_controls_sec fbcs
107: , fa_distribution_history fdh
108: , fa_deprn_periods fdp
109: WHERE fth.transaction_type_code IN
110: ('ADDITION', 'ADJUSTMENT', 'RECLASS', 'REINSTATEMENT',
111: 'REVALUATION', 'TRANSFER', 'UNIT ADJUSTMENT',
112: 'RESERVE ADJUSTMENT')

Line 230: fa_deprn_periods fdp

226: MAX(fdp.period_close_date)
227: INTO
228: ld_dp_close_date
229: FROM
230: fa_deprn_periods fdp
231: WHERE greatest(greatest(fdp.calendar_period_open_date,
232: least(SYSDATE, fdp.calendar_period_close_date)),
233: fdp.calendar_period_open_date) <= v_row.transaction_date;
234: --get the total unit at the transaction time

Line 617: fa_deprn_periods fdp

613: fds.impairment_reserve
614: INTO lv_before(1), lv_after(1)
615: FROM fa_deprn_summary fds,
616: fa_deprn_summary fds1,
617: fa_deprn_periods fdp
618: WHERE fds.asset_id = v_row.asset_id
619: AND fds1.asset_id = v_row.asset_id
620: AND fdp.book_type_code = v_row.book_type_code
621: AND fdp.book_type_code = fds.book_type_code