APPS.FA_GAINLOSS_UND_PKG dependencies on FA_BOOK_CONTROLS

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

370: bc.book_type_code,
371: retire.transaction_header_id_out,
372: retire.transaction_header_id_in,
373: bk.group_asset_id
374: FROM fa_book_controls bc, fa_retirements retire, fa_books bk
375: WHERE
376: retire.retirement_id = RET.retirement_id
377: AND retire.units is not null
378: AND bc.distribution_source_book = retire.book_type_code

Line 391: FROM fa_mc_book_controls fmcbc,fa_book_controls fbc, fa_mc_retirements retire, fa_mc_books bk

387: fmcbc.book_type_code,
388: retire.transaction_header_id_out,
389: retire.transaction_header_id_in,
390: bk.group_asset_id
391: FROM fa_mc_book_controls fmcbc,fa_book_controls fbc, fa_mc_retirements retire, fa_mc_books bk
392: WHERE
393: retire.retirement_id = RET.retirement_id
394: AND retire.units is not null
395: AND fbc.distribution_source_book = retire.book_type_code

Line 583: FA_BOOK_CONTROLS BC,

579: INTO
580: h_is_prior_period
581: FROM
582: FA_TRANSACTION_HEADERS TH,
583: FA_BOOK_CONTROLS BC,
584: FA_DEPRN_PERIODS DP,
585: FA_DEPRN_PERIODS DP_NOW
586: WHERE
587: TH.ASSET_ID = h_asset_id AND

Line 1146: fa_book_controls bc

1142: --Select active distribution_ids
1143: CURSOR TRET IS
1144: SELECT fadh.distribution_id
1145: FROM fa_distribution_history fadh,
1146: fa_book_controls bc
1147: WHERE fadh.asset_id = h_asset_id
1148: AND fadh.book_type_code = bc.distribution_source_book
1149: AND bc.book_type_code = h_book
1150: AND fadh.date_ineffective is null

Line 1157: fa_book_controls bc,

1153: -- Select distribution_ids that were retired
1154: CURSOR PRET IS
1155: SELECT dh.distribution_id
1156: FROM fa_distribution_history dh,
1157: fa_book_controls bc,
1158: fa_retirements rt
1159: WHERE dh.asset_id = h_asset_id
1160: AND dh.book_type_code = bc.distribution_source_book
1161: AND bc.book_type_code = h_book

Line 1174: fa_book_controls bc,

1170: SELECT dh_old.distribution_id,
1171: dh_new.distribution_id
1172: FROM fa_distribution_history dh_old,
1173: fa_distribution_history dh_new,
1174: fa_book_controls bc,
1175: fa_transaction_headers th
1176: WHERE th.transaction_header_id = h_rethdrout
1177: and th.asset_id = h_asset_id
1178: and th.book_type_code = h_book

Line 1288: FROM gl_sets_of_books GL, fa_book_controls FA

1284: -- CHECK to see if the following can be replaced with ret.mrc_sob_type_code
1285: -- select returns 0: if reporting book... 1: if primary book
1286: SELECT count(*)
1287: INTO h_mrc_primary_book_flag
1288: FROM gl_sets_of_books GL, fa_book_controls FA
1289: WHERE gl.set_of_books_id = fa.set_of_books_id
1290: AND fa.book_type_code = h_book
1291: AND gl.mrc_sob_type_code <> 'R'
1292: AND rownum <= 1;