DBA Data[Home] [Help]

APPS.FA_INS_DETAIL_PKG dependencies on FA_BOOKS

Line 99: FROM FA_BOOKS_MRC_V bk,

95: SELECT decode(ad.asset_type,
96: 'GROUP', 0,
97: bk.cost)
98: INTO h_cost
99: FROM FA_BOOKS_MRC_V bk,
100: FA_ADDITIONS_B ad
101: WHERE ad.asset_id = X_asset_id
102: AND ad.asset_id = bk.asset_id
103: AND bk.book_type_code = X_book_type_code

Line 132: FROM FA_BOOKS bk,

128: SELECT decode(ad.asset_type,
129: 'GROUP', 0,
130: bk.cost)
131: INTO h_cost
132: FROM FA_BOOKS bk,
133: FA_ADDITIONS_B ad
134: WHERE ad.asset_id = X_asset_id
135: AND ad.asset_id = bk.asset_id
136: AND bk.book_type_code = X_book_type_code