APPS.JA_CN_FA_ADI_EXPORT_PKG dependencies on FA_DEPRN_PERIODS

Line 90: fa_deprn_periods fdp

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')
94: AND fth.asset_id = fa.asset_id

Line 154: fa_deprn_periods fdp

150: FROM fa_retirements fr,
151: fa_books fb,
152: fa_books fbb,
153: fa_deprn_summary fds,
154: fa_deprn_periods fdp
155: WHERE fr.asset_id = ln_asset_id
156: AND fr.transaction_header_id_in = ln_transaction_header_id
157: AND fds.book_type_code = lv_book_type_code
158: AND fb.asset_id = fr.asset_id

Line 253: FROM fa_deprn_periods fdp

249: 'transaction_header_id' || v_row.transaction_header_id
250: ||' transaction_date' ||v_row.transaction_date);
251: SELECT max(fdp.period_close_date)
252: INTO ld_dp_close_date
253: FROM fa_deprn_periods fdp
254: WHERE greatest(greatest(fdp.calendar_period_open_date,
255: least(SYSDATE, fdp.calendar_period_close_date)),
256: fdp.calendar_period_open_date) <= v_row.transaction_date;
257: --get the total unit at the transaction time