APPS.FA_CALC_DEPRN_BASIS1_PKG dependencies on FA_DEPRN_PERIODS

Line 5: 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.67.12010000.4 2009/02/04 14:22:51 souroy ship $ */
3: -- global variables
4: g_log_level_rec fa_api_types.log_level_rec_type;
5: g_book_type_code fa_deprn_periods.book_type_code%TYPE;
6: g_fiscal_year1 fa_fiscal_year.fiscal_year%TYPE;
7: g_fiscal_year2 fa_fiscal_year.fiscal_year%TYPE;
8: g_period_num1 fa_calendar_periods.period_num%TYPE;
9: g_period_num2 fa_calendar_periods.period_num%TYPE;

Line 947: fa_deprn_periods dp

943:
944: select count(*)
945: into l_last_trx_count
946: from fa_books bks,
947: fa_deprn_periods dp
948: where bks.asset_id = l_asset_id
949: and bks.book_type_code = l_book_type_code
950: and bks.date_ineffective is null
951: and dp.book_type_code = l_book_type_code

Line 1390: FA_DEPRN_PERIODS dp,

1386: fy.mid_year_date fy_mid_year_date,
1387: dp.calendar_period_open_date cp_start_date,
1388: dp.calendar_period_close_date cp_end_date
1389: from FA_FISCAL_YEAR fy,
1390: FA_DEPRN_PERIODS dp,
1391: FA_BOOK_CONTROLS bc
1392: where bc.book_type_code = dp.book_type_code
1393: and fy.fiscal_year = dp.fiscal_year
1394: and bc.fiscal_year_name = fy.fiscal_year_name

Line 1406: FA_DEPRN_PERIODS_MRC_V dp,

1402: fy.mid_year_date fy_mid_year_date,
1403: dp.calendar_period_open_date cp_start_date,
1404: dp.calendar_period_close_date cp_end_date
1405: from FA_FISCAL_YEAR fy,
1406: FA_DEPRN_PERIODS_MRC_V dp,
1407: FA_BOOK_CONTROLS_MRC_V bc
1408: where bc.book_type_code = dp.book_type_code
1409: and fy.fiscal_year = dp.fiscal_year
1410: and bc.fiscal_year_name = fy.fiscal_year_name

Line 3702: FA_DEPRN_PERIODS dp,

3698: cursor C_GET_DATE is
3699: select fy.start_date fy_start_date,
3700: dp.calendar_period_close_date cp_end_date
3701: from FA_FISCAL_YEAR fy,
3702: FA_DEPRN_PERIODS dp,
3703: FA_BOOK_CONTROLS bc
3704: where bc.book_type_code = dp.book_type_code
3705: and fy.fiscal_year = dp.fiscal_year
3706: and bc.fiscal_year_name = fy.fiscal_year_name

Line 3714: FA_DEPRN_PERIODS_MRC_V dp,

3710: cursor C_GET_DATE_M is
3711: select fy.start_date fy_start_date,
3712: dp.calendar_period_close_date cp_end_date
3713: from FA_FISCAL_YEAR fy,
3714: FA_DEPRN_PERIODS_MRC_V dp,
3715: FA_BOOK_CONTROLS_MRC_V bc
3716: where bc.book_type_code = dp.book_type_code
3717: and fy.fiscal_year = dp.fiscal_year
3718: and bc.fiscal_year_name = fy.fiscal_year_name