APPS.JL_CO_FA_ACCOUNTING_PKG dependencies on FA_DEPRN_PERIODS

Line 75: x_period_name fa_deprn_periods.period_name%TYPE;

71: x_chart_of_accounts_id fa_book_controls.accounting_flex_structure%TYPE;
72: x_corporate_book fa_book_controls.book_type_code%TYPE;
73: x_period_counter fa_book_controls.last_period_counter%TYPE;
74: x_account_period fa_book_controls.last_period_counter%TYPE;
75: x_period_name fa_deprn_periods.period_name%TYPE;
76: x_deprn_date fa_deprn_periods.period_open_date%TYPE;
77:
78: x_currency_code gl_sets_of_books.currency_code%TYPE;
79: x_precision fnd_currencies.precision%TYPE;

Line 76: x_deprn_date fa_deprn_periods.period_open_date%TYPE;

72: x_corporate_book fa_book_controls.book_type_code%TYPE;
73: x_period_counter fa_book_controls.last_period_counter%TYPE;
74: x_account_period fa_book_controls.last_period_counter%TYPE;
75: x_period_name fa_deprn_periods.period_name%TYPE;
76: x_deprn_date fa_deprn_periods.period_open_date%TYPE;
77:
78: x_currency_code gl_sets_of_books.currency_code%TYPE;
79: x_precision fnd_currencies.precision%TYPE;
80: x_extended_precision fnd_currencies.extended_precision%TYPE;

Line 340: fa_deprn_periods dp,

336: fnd_number.canonical_to_number(nvl (bk.global_attribute2,0)) appraisal_balance,
337: fnd_number.canonical_to_number(nvl (bk.global_attribute7,0)) deprn_to_cost,
338: bk.rowid book_rowid
339: FROM fa_transaction_headers th,
340: fa_deprn_periods dp,
341: fa_additions ad,
342: fa_asset_history ah,
343: fa_books bk
344: WHERE dp.book_type_code = pc_tax_book

Line 386: fa_deprn_periods dp,

382: fnd_number.canonical_to_number(nvl (bk.global_attribute2,0)),
383: fnd_number.canonical_to_number(nvl (bk.global_attribute7,0)),
384: bk.rowid
385: FROM fa_transaction_headers th,
386: fa_deprn_periods dp,
387: fa_additions ad,
388: fa_asset_history ah,
389: fa_books bk
390: WHERE dp.book_type_code = pc_corporate_book

Line 677: fa_deprn_periods dp,

673: nvl (rt.gain_loss_amount,0),
674: dp.period_counter,
675: th.transaction_type_code
676: FROM fa_retirements rt,
677: fa_deprn_periods dp,
678: fa_transaction_headers th
679: WHERE rt.transaction_header_id_out = pc_transaction_header_id
680: AND dp.book_type_code = rt.book_type_code
681: AND dp.period_open_date <= rt.date_effective

Line 851: fa_deprn_periods dp,

847: x_period_name,
848: x_deprn_date,
849: x_currency_code
850: FROM fa_book_controls bc,
851: fa_deprn_periods dp,
852: gl_sets_of_books sb
853: WHERE bc.book_type_code = p_tax_book
854: AND dp.book_type_code = bc.book_type_code
855: AND dp.period_counter = bc.last_period_counter