APPS.FA_PROCESS_IMPAIRMENT_PKG dependencies on FA_CALENDAR_PERIODS

Line 75: , fa_calendar_periods cp

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
79: and ct.fiscal_year_name = bc.fiscal_year_name

Line 95: , fa_calendar_periods cp

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
99: and bc.deprn_calendar = ct.calendar_type

Line 307: , fa_calendar_periods cp

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
311: and ct.calendar_type = cp.calendar_type

Line 329: , fa_calendar_periods cp

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
333: and ct.calendar_type = cp.calendar_type