APPS.FA_CALC_DEPRN_BASIS1_PKG dependencies on FA_DEPRN_PERIODS

Line 4: g_book_type_code fa_deprn_periods.book_type_code%TYPE;

1: PACKAGE BODY FA_CALC_DEPRN_BASIS1_PKG as
2: /* $Header: faxcdb1b.pls 120.96.12020000.4 2013/03/19 18:01:39 dvjoshi ship $ */
3: -- global variables
4: g_book_type_code fa_deprn_periods.book_type_code%TYPE;
5: g_fiscal_year1 fa_fiscal_year.fiscal_year%TYPE;
6: g_fiscal_year2 fa_fiscal_year.fiscal_year%TYPE;
7: g_period_num1 fa_calendar_periods.period_num%TYPE;
8: g_period_num2 fa_calendar_periods.period_num%TYPE;

Line 1052: fa_deprn_periods dp

1048:
1049: select count(*)
1050: into l_last_trx_count
1051: from fa_books bks,
1052: fa_deprn_periods dp
1053: where bks.asset_id = l_asset_id
1054: and bks.book_type_code = l_book_type_code
1055: and bks.date_ineffective is null
1056: and dp.book_type_code = l_book_type_code

Line 1515: FA_DEPRN_PERIODS dp,

1511: fy.mid_year_date fy_mid_year_date,
1512: dp.calendar_period_open_date cp_start_date,
1513: dp.calendar_period_close_date cp_end_date
1514: from FA_FISCAL_YEAR fy,
1515: FA_DEPRN_PERIODS dp,
1516: FA_BOOK_CONTROLS bc
1517: where bc.book_type_code = dp.book_type_code
1518: and fy.fiscal_year = dp.fiscal_year
1519: and bc.fiscal_year_name = fy.fiscal_year_name

Line 4126: FA_DEPRN_PERIODS dp,

4122: cursor C_GET_DATE is
4123: select fy.start_date fy_start_date,
4124: dp.calendar_period_close_date cp_end_date
4125: from FA_FISCAL_YEAR fy,
4126: FA_DEPRN_PERIODS dp,
4127: FA_BOOK_CONTROLS bc
4128: where bc.book_type_code = dp.book_type_code
4129: and fy.fiscal_year = dp.fiscal_year
4130: and bc.fiscal_year_name = fy.fiscal_year_name