DBA Data[Home] [Help]

APPS.FA_ASSET_DESC_PUB dependencies on FA_BOOKS

Line 121: from fa_books bks

117: where bc.book_class = 'CORPORATE'
118: and exists
119: (
120: select 'X'
121: from fa_books bks
122: where bks.asset_id = px_asset_hdr_rec.asset_id
123: and bks.book_type_code = bc.book_type_code
124: );
125: end if;

Line 1431: FROM fa_books bks,

1427:
1428: -- Bug 5475276 Cursor to get the book_type_code
1429: CURSOR c_corp_book( p_asset_id number ) IS
1430: SELECT bc.book_type_code
1431: FROM fa_books bks,
1432: fa_book_controls bc
1433: WHERE bks.book_type_code = bc.distribution_source_book
1434: AND bks.book_type_code = bc.book_type_code
1435: AND bks.asset_id = p_asset_id