DBA Data[Home] [Help]

APPS.FA_TOFES_YUD_ALEF_PKG dependencies on FA_ADDITIONS_B

Line 230: ,FA_ADDITIONS_B FA

226: INTO ld_date
227: FROM AP_INVOICES_ALL
228: WHERE INVOICE_ID IN (SELECT FAI.INVOICE_ID
229: FROM FA_ASSET_INVOICES FAI
230: ,FA_ADDITIONS_B FA
231: ,FA_BOOKS FB
232: WHERE FAI.ASSET_ID = FA.ASSET_ID
233: AND FA.ASSET_ID = FB.ASSET_ID
234: AND FA.ASSET_ID = p_asset_id_in

Line 238: ,FA_ADDITIONS_B FA

234: AND FA.ASSET_ID = p_asset_id_in
235: AND FB.BOOK_TYPE_CODE = P_BOOK_NAME)
236: AND VENDOR_ID IN (SELECT FAI.PO_VENDOR_ID
237: FROM FA_ASSET_INVOICES FAI
238: ,FA_ADDITIONS_B FA
239: ,FA_BOOKS FB
240: WHERE FAI.ASSET_ID = FA.ASSET_ID
241: AND FA.ASSET_ID = FB.ASSET_ID
242: AND FA.ASSET_ID = p_asset_id_in

Line 250: FROM FA_ADDITIONS_B FA

246: EXCEPTION
247: WHEN NO_DATA_FOUND THEN
248: SELECT FB.DATE_PLACED_IN_SERVICE
249: INTO ld_date
250: FROM FA_ADDITIONS_B FA
251: ,FA_BOOKS FB
252: WHERE FA.ASSET_ID = FB.ASSET_ID
253: AND FA.ASSET_ID = p_asset_id_in
254: AND FB.BOOK_TYPE_CODE = P_BOOK_NAME