DBA Data[Home] [Help]

APPS.FA_GAINLOSS_RET_PKG dependencies on FA_BOOK_CONTROLS

Line 298: fa_book_controls bc,

294: fa_books book_grp,
295: fa_methods m,
296: fa_conventions conv,
297: fa_convention_types ctype,
298: fa_book_controls bc,
299: fa_asset_history ah
300: WHERE
301: book.retirement_id = h_retirement_id
302: AND book.asset_id = h_asset_id

Line 477: fa_book_controls bc_primary, -- added this to get fiscal year name

473: fa_methods m,
474: fa_conventions conv,
475: fa_convention_types ctype,
476: fa_mc_book_controls bc,
477: fa_book_controls bc_primary, -- added this to get fiscal year name
478: fa_asset_history ah
479: WHERE
480: book.retirement_id = h_retirement_id
481: AND book.asset_id = h_asset_id

Line 1431: fa_book_controls fbc

1427: cursor c_prd_flag is
1428: select 'Y'
1429: from fa_calendar_periods fcp1,
1430: fa_calendar_periods fcp2,
1431: fa_book_controls fbc
1432: where to_date (dpr.prorate_jdate,'J') BETWEEN fcp1.start_date and fcp1.end_date
1433: and fbc.book_type_code = dpr.book
1434: and fcp1.calendar_type = fbc.deprn_calendar
1435: and to_date (decode( dpr.jdate_retired,0,null,dpr.jdate_retired),'J') BETWEEN fcp2.start_date and fcp2.end_date