DBA Data[Home] [Help]

APPS.FA_TOFES_YUD_ALEF_PKG dependencies on FA_ADDITIONS_B

Line 333: ,FA_ADDITIONS_B FA

329: INTO ld_date
330: FROM AP_INVOICES_ALL
331: WHERE INVOICE_ID IN (SELECT FAI.INVOICE_ID
332: FROM FA_ASSET_INVOICES FAI
333: ,FA_ADDITIONS_B FA
334: ,FA_BOOKS FB
335: WHERE FAI.ASSET_ID = FA.ASSET_ID
336: AND FA.ASSET_ID = FB.ASSET_ID
337: AND FA.ASSET_ID = p_asset_id_in

Line 341: ,FA_ADDITIONS_B FA

337: AND FA.ASSET_ID = p_asset_id_in
338: AND FB.BOOK_TYPE_CODE = P_BOOK_NAME)
339: AND VENDOR_ID IN (SELECT FAI.PO_VENDOR_ID
340: FROM FA_ASSET_INVOICES FAI
341: ,FA_ADDITIONS_B FA
342: ,FA_BOOKS FB
343: WHERE FAI.ASSET_ID = FA.ASSET_ID
344: AND FA.ASSET_ID = FB.ASSET_ID
345: AND FA.ASSET_ID = p_asset_id_in

Line 354: FROM FA_ADDITIONS_B FA

350: --Bug#9237853
351: WHEN OTHERS THEN
352: SELECT FB.DATE_PLACED_IN_SERVICE
353: INTO ld_date
354: FROM FA_ADDITIONS_B FA
355: ,FA_BOOKS FB
356: WHERE FA.ASSET_ID = FB.ASSET_ID
357: AND FA.ASSET_ID = p_asset_id_in
358: AND FB.BOOK_TYPE_CODE = P_BOOK_NAME