APPS.FA_QUERY_BALANCES_PKG dependencies on FA_BOOKS

Line 70: from fa_books

66: l_mrc_sob_type_code varchar2(1);
67:
68: cursor c_get_group_info is
69: select group_asset_id, member_rollup_flag
70: from fa_books
71: where asset_id = X_ASSET_ID
72: and book_type_code = X_BOOK
73: and transaction_header_id_out is null;
74:

Line 913: from fa_books bk

909: sum(NVL(PRIOR_FY_EXPENSE, 0)),
910: sum(NVL(PRIOR_FY_BONUS_EXPENSE, 0))
911: FROM FA_DEPRN_SUMMARY_MRC_V DS
912: WHERE DS.ASSET_ID in (select bk.asset_id
913: from fa_books bk
914: where bk.book_type_code = x_dpr_row.book
915: and bk.transaction_header_id_out is null
916: and bk.group_asset_id = x_dpr_row.asset_id)
917: AND DS.BOOK_TYPE_CODE = X_dpr_row.book

Line 972: from fa_books bk

968: sum(NVL(PRIOR_FY_EXPENSE, 0)),
969: sum(NVL(PRIOR_FY_BONUS_EXPENSE, 0))
970: FROM FA_DEPRN_SUMMARY DS
971: WHERE DS.ASSET_ID in (select bk.asset_id
972: from fa_books bk
973: where bk.book_type_code = x_dpr_row.book
974: and bk.transaction_header_id_out is null
975: and bk.group_asset_id = x_dpr_row.asset_id)
976: AND DS.BOOK_TYPE_CODE = X_dpr_row.book

Line 1830: from fa_books_mrc_v bk

1826: h_cip_clearing_adjs,
1827: h_num_adjs
1828: FROM FA_ADJUSTMENTS_MRC_V ADJ
1829: WHERE ADJ.ASSET_ID in (select bk.asset_id
1830: from fa_books_mrc_v bk
1831: where bk.book_type_code = x_adj_row.book
1832: and bk.transaction_header_id_out is null
1833: and bk.group_asset_id = x_adj_row.asset_id) AND
1834: ADJ.BOOK_TYPE_CODE = X_ADJ_ROW.book AND

Line 1935: from fa_books bk

1931: h_cip_clearing_adjs,
1932: h_num_adjs
1933: FROM FA_ADJUSTMENTS ADJ
1934: WHERE ADJ.ASSET_ID in (select bk.asset_id
1935: from fa_books bk
1936: where bk.book_type_code = x_adj_row.book
1937: and bk.transaction_header_id_out is null
1938: and bk.group_asset_id = x_adj_row.asset_id) AND
1939: ADJ.BOOK_TYPE_CODE = X_ADJ_ROW.book AND