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 659: fa_book_controls fbc

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

Line 707: fa_book_controls fbc

703:
704: select fb.book_type_code
705: into l_asset_assignment_tbl(1).fa_book_type_code
706: from fa_books fb,
707: fa_book_controls fbc
708: where fb.asset_id = l_asset_assignment_tbl(1).fa_asset_id
709: and fb.book_type_code = fbc.book_type_code
710: and fbc.book_class = 'CORPORATE'
711: and rownum = 1;