APPS.FA_PROCESS_IMPAIRMENT_PKG dependencies on FA_CALENDAR_TYPES

Line 74: , fa_calendar_types ct

70: , cp.period_num period_num
71: , fy.fiscal_year fiscal_year
72: from fa_book_controls bc
73: , fa_fiscal_year fy
74: , fa_calendar_types ct
75: , fa_calendar_periods cp
76: where bc.book_type_code = p_book_type_code
77: and bc.deprn_calendar = ct.calendar_type
78: and bc.fiscal_year_name = fy.fiscal_year_name

Line 94: , fa_calendar_types ct

90: , fy.fiscal_year fiscal_year
91: from fa_book_controls bc
92: , fa_mc_book_controls mbc
93: , fa_fiscal_year fy
94: , fa_calendar_types ct
95: , fa_calendar_periods cp
96: where bc.book_type_code = p_book_type_code
97: and mbc.book_type_code = p_book_type_code
98: and mbc.set_of_books_id = l_set_of_books_id

Line 306: , fa_calendar_types ct

302: , imp.PERIOD_COUNTER_IMPAIRED =
303: (select nvl(imp.PERIOD_COUNTER_IMPAIRED,
304: fy.fiscal_year * ct.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM)
305: from fa_fiscal_year fy
306: , fa_calendar_types ct
307: , fa_calendar_periods cp
308: where fa_cache_pkg.fazcbc_record.deprn_calendar = ct.calendar_type
309: and fa_cache_pkg.fazcbc_record.fiscal_year_name = fy.fiscal_year_name
310: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name

Line 328: , fa_calendar_types ct

324: , imp.PERIOD_COUNTER_IMPAIRED =
325: (select nvl(imp.PERIOD_COUNTER_IMPAIRED,
326: fy.fiscal_year * ct.NUMBER_PER_FISCAL_YEAR + cp.PERIOD_NUM)
327: from fa_fiscal_year fy
328: , fa_calendar_types ct
329: , fa_calendar_periods cp
330: where fa_cache_pkg.fazcbc_record.deprn_calendar = ct.calendar_type
331: and fa_cache_pkg.fazcbc_record.fiscal_year_name = fy.fiscal_year_name
332: and ct.fiscal_year_name = fa_cache_pkg.fazcbc_record.fiscal_year_name