DBA Data[Home] [Help]

APPS.FA_ASSET_VAL_PVT dependencies on FA_CALENDAR_TYPES

Line 4617: ,fa_calendar_types fct

4613: select fcp.end_date
4614: from fa_fiscal_year ffy
4615: ,fa_book_controls fbc
4616: ,fa_calendar_periods fcp
4617: ,fa_calendar_types fct
4618: where ffy.fiscal_year_name = fbc.fiscal_year_name
4619: and ffy.fiscal_year_name = fct.fiscal_year_name
4620: and fbc.book_type_code = p_book_type_code
4621: and fcp.calendar_type = fct.calendar_type

Line 4726: ,fa_calendar_types fct

4722: select fcp.end_date
4723: from fa_fiscal_year ffy
4724: ,fa_book_controls fbc
4725: ,fa_calendar_periods fcp
4726: ,fa_calendar_types fct
4727: where ffy.fiscal_year_name = fbc.fiscal_year_name
4728: and ffy.fiscal_year_name = fct.fiscal_year_name
4729: and fbc.book_type_code = p_book_type_code
4730: and fcp.calendar_type = fct.calendar_type

Line 4833: ,fa_calendar_types fct

4829: select fcp.end_date
4830: from fa_fiscal_year ffy
4831: ,fa_book_controls fbc
4832: ,fa_calendar_periods fcp
4833: ,fa_calendar_types fct
4834: where ffy.fiscal_year_name = fbc.fiscal_year_name
4835: and ffy.fiscal_year_name = fct.fiscal_year_name
4836: and fbc.book_type_code = p_book_type_code
4837: and fcp.calendar_type = fct.calendar_type

Line 6007: ,fa_calendar_types fct

6003: ,fct.number_per_fiscal_year
6004: from fa_fiscal_year ffy
6005: ,fa_book_controls fbc
6006: ,fa_calendar_periods fcp
6007: ,fa_calendar_types fct
6008: where ffy.fiscal_year_name = fbc.fiscal_year_name
6009: and ffy.fiscal_year_name = fct.fiscal_year_name
6010: and fbc.book_type_code = p_book_type_code
6011: and fcp.calendar_type = fct.calendar_type