DBA Data[Home] [Help]

APPS.EAM_ASSET_NUMBER_PVT dependencies on FA_BOOK_CONTROLS

Line 341: fa_book_controls fbc

337:
338: select fb.book_type_code
339: into l_asset_assignment_tbl(1).fa_book_type_code
340: from fa_books fb,
341: fa_book_controls fbc
342: where fb.asset_id = P_FA_ASSET_ID
343: and fb.book_type_code = fbc.book_type_code
344: and fbc.book_class = 'CORPORATE'
345: and rownum = 1;

Line 662: fa_book_controls fbc

658:
659: select fb.book_type_code
660: into l_asset_assignment_tbl(1).fa_book_type_code
661: from fa_books fb,
662: fa_book_controls fbc
663: where fb.asset_id = P_FA_ASSET_ID
664: and fb.book_type_code = fbc.book_type_code
665: and fbc.book_class = 'CORPORATE'
666: and rownum = 1;

Line 713: fa_book_controls fbc

709:
710: select fb.book_type_code
711: into l_asset_assignment_tbl(1).fa_book_type_code
712: from fa_books fb,
713: fa_book_controls fbc
714: where fb.asset_id = l_asset_assignment_tbl(1).fa_asset_id
715: and fb.book_type_code = fbc.book_type_code
716: and fbc.book_class = 'CORPORATE'
717: and rownum = 1;