DBA Data[Home] [Help]

APPS.FA_MASSADD_PKG dependencies on FA_FISCAL_YEAR

Line 1896: fa_fiscal_year fy1,

1892: fy1.end_date
1893: from fa_books bk,
1894: fa_additions ad,
1895: fa_book_controls bc,
1896: fa_fiscal_year fy1,
1897: fa_fiscal_year fy2,
1898: fa_calendar_periods cp1
1899: where ad.asset_category_id = p_category_id
1900: and ad.asset_type = p_asset_type

Line 1897: fa_fiscal_year fy2,

1893: from fa_books bk,
1894: fa_additions ad,
1895: fa_book_controls bc,
1896: fa_fiscal_year fy1,
1897: fa_fiscal_year fy2,
1898: fa_calendar_periods cp1
1899: where ad.asset_category_id = p_category_id
1900: and ad.asset_type = p_asset_type
1901: and bk.book_type_code = p_book_type_code

Line 2095: From fa_fiscal_year fy,

2091: l_new_desc_year,
2092: l_new_desc_category,
2093: l_new_start_date,
2094: l_new_end_date
2095: From fa_fiscal_year fy,
2096: fa_book_controls bc,
2097: fa_categories cat
2098: Where px_date_placed_in_service_tbl(i) between fy.start_date and fy.end_date
2099: And fy.fiscal_year_name = bc.fiscal_year_name