APPS.FA_GAINLOSS_UND_PKG dependencies on FA_BOOK_CONTROLS

Line 477: FROM fa_book_controls bc, fa_retirements retire, fa_books bk

473: retire.transaction_header_id_in,
474: bk.group_asset_id,
475: bk.member_rollup_flag,
476: bk.tracking_method
477: FROM fa_book_controls bc, fa_retirements retire, fa_books bk
478: WHERE
479: retire.retirement_id = RET.retirement_id
480: AND retire.units is not null
481: AND bc.distribution_source_book = retire.book_type_code

Line 496: FROM fa_mc_book_controls fmcbc,fa_book_controls fbc, fa_retirements retire, fa_mc_books bk

492: retire.transaction_header_id_in,
493: bk.group_asset_id,
494: bk.member_rollup_flag,
495: bk.tracking_method
496: FROM fa_mc_book_controls fmcbc,fa_book_controls fbc, fa_retirements retire, fa_mc_books bk
497: WHERE
498: retire.retirement_id = RET.retirement_id
499: AND retire.units is not null
500: AND fbc.distribution_source_book = retire.book_type_code

Line 637: FA_BOOK_CONTROLS BC,

633: INTO
634: h_is_prior_period
635: FROM
636: FA_TRANSACTION_HEADERS TH,
637: FA_BOOK_CONTROLS BC,
638: FA_DEPRN_PERIODS DP,
639: FA_DEPRN_PERIODS DP_NOW
640: WHERE
641: TH.ASSET_ID = h_asset_id AND

Line 1415: fa_book_controls bc

1411: --Select active distribution_ids
1412: CURSOR TRET IS
1413: SELECT fadh.distribution_id
1414: FROM fa_distribution_history fadh,
1415: fa_book_controls bc
1416: WHERE fadh.asset_id = h_asset_id
1417: AND fadh.book_type_code = bc.distribution_source_book
1418: AND bc.book_type_code = h_book
1419: AND fadh.date_ineffective is null

Line 1426: fa_book_controls bc,

1422: -- Select distribution_ids that were retired
1423: CURSOR PRET IS
1424: SELECT dh.distribution_id
1425: FROM fa_distribution_history dh,
1426: fa_book_controls bc,
1427: fa_retirements rt
1428: WHERE dh.asset_id = h_asset_id
1429: AND dh.book_type_code = bc.distribution_source_book
1430: AND bc.book_type_code = h_book

Line 1443: fa_book_controls bc,

1439: SELECT dh_old.distribution_id,
1440: dh_new.distribution_id
1441: FROM fa_distribution_history dh_old,
1442: fa_distribution_history dh_new,
1443: fa_book_controls bc,
1444: fa_transaction_headers th
1445: WHERE th.transaction_header_id = h_rethdrout
1446: and th.asset_id = h_asset_id
1447: and th.book_type_code = h_book

Line 1570: FROM gl_sets_of_books GL, fa_book_controls FA

1566: -- CHECK to see if the following can be replaced with ret.mrc_sob_type_code
1567: -- select returns 0: if reporting book... 1: if primary book
1568: SELECT count(*)
1569: INTO h_mrc_primary_book_flag
1570: FROM gl_sets_of_books GL, fa_book_controls FA
1571: WHERE gl.set_of_books_id = fa.set_of_books_id
1572: AND fa.book_type_code = h_book
1573: AND gl.mrc_sob_type_code <> 'R'
1574: AND rownum <= 1;