DBA Data[Home] [Help]

APPS.EAM_ASSET_NUMBER_PVT dependencies on FA_BOOKS

Line 340: from fa_books fb,

336: end if;
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'

Line 658: from fa_books fb,

654: end if;
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'

Line 706: from fa_books fb,

702: end if;
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'