APPS.FA_AMORT_PVT dependencies on FA_CALENDAR_TYPES

Line 75: FROM fa_calendar_periods fcp, fa_calendar_types fct, fa_fiscal_year ffy

71: l_calling_fn varchar2(40) := 'FA_AMORT_PVT.get_dcal_pc';
72: BEGIN
73: SELECT fcp.period_num +( fct.number_per_fiscal_year * ffy.fiscal_year)
74: INTO l_pc
75: FROM fa_calendar_periods fcp, fa_calendar_types fct, fa_fiscal_year ffy
76: WHERE pp_date BETWEEN fcp.start_date AND fcp.end_date
77: AND pp_date BETWEEN ffy.start_date AND ffy.end_date
78: AND fct.calendar_type = fcp.calendar_type
79: AND ffy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name

Line 361: , fa_calendar_types ct

357: , fy.fiscal_year fiscal_year
358: , 'N'
359: from fa_book_controls bc
360: , fa_fiscal_year fy
361: , fa_calendar_types ct
362: , fa_calendar_periods cp
363: where bc.book_type_code = p_asset_hdr_rec.book_type_code
364: and bc.deprn_calendar = ct.calendar_type
365: and bc.fiscal_year_name = fy.fiscal_year_name

Line 1039: , fa_calendar_types ct

1035: , cp.period_num period_num
1036: , fy.fiscal_year fiscal_year
1037: , 'N'
1038: from fa_fiscal_year fy
1039: , fa_calendar_types ct
1040: , fa_calendar_periods cp
1041: where ct.calendar_type = fa_cache_pkg.fazcbc_record.deprn_calendar
1042: and fy.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name
1043: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name

Line 7676: fa_calendar_types ct,

7672: add_amort_period
7673: from fa_calendar_periods cp,
7674: fa_book_controls bc,
7675: fa_fiscal_year fy,
7676: fa_calendar_types ct,
7677: fa_transaction_headers th
7678: WHERE th.book_type_code = p_asset_hdr_rec.book_type_code
7679: and th.asset_id = p_asset_hdr_rec.asset_id
7680: and bc.book_type_code = th.book_type_code

Line 11639: fa_calendar_types ct,

11635: select fy.fiscal_year
11636: from fa_calendar_periods cp,
11637: fa_book_controls bc,
11638: fa_fiscal_year fy,
11639: fa_calendar_types ct,
11640: fa_books bk
11641: WHERE bk.book_type_code = p_asset_hdr_rec.book_type_code
11642: and bk.asset_id = p_asset_hdr_rec.asset_id
11643: and bk.transaction_header_id_out is null

Line 13217: fa_calendar_types ct,

13213: into l_ret_prorate_pc
13214: from fa_calendar_periods cp,
13215: fa_book_controls bc,
13216: fa_fiscal_year fy,
13217: fa_calendar_types ct,
13218: fa_retirements ret,
13219: fa_conventions con
13220: WHERE ret.book_type_code = p_asset_hdr_rec.book_type_code
13221: and ret.asset_id = p_asset_hdr_rec.asset_id