APPS.FA_TOFES_YUD_ALEF_PKG dependencies on FA_ASSET_INVOICES

Line 332: FROM FA_ASSET_INVOICES FAI

328: SELECT INVOICE_DATE
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

Line 340: FROM FA_ASSET_INVOICES FAI

336: AND FA.ASSET_ID = FB.ASSET_ID
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

Line 461: LP_FA_ASSET_INVOICES := 'FA_ASSET_INVOICES_MRC_V';

457: LP_FA_BOOKS := 'FA_BOOKS_MRC_V';
458: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS_MRC_V';
459: LP_FA_RETIREMENTS := 'FA_RETIREMENTS_MRC_V';
460: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS_MRC_V';
461: LP_FA_ASSET_INVOICES := 'FA_ASSET_INVOICES_MRC_V';
462: ELSE
463: lp_fa_book_controls := 'FA_BOOK_CONTROLS';
464: lp_fa_books := 'FA_BOOKS';
465: lp_fa_adjustments := 'FA_ADJUSTMENTS';

Line 468: lp_fa_asset_invoices := 'FA_ASSET_INVOICES';

464: lp_fa_books := 'FA_BOOKS';
465: lp_fa_adjustments := 'FA_ADJUSTMENTS';
466: lp_fa_retirements := 'FA_RETIREMENTS';
467: lp_fa_deprn_periods := 'FA_DEPRN_PERIODS';
468: lp_fa_asset_invoices := 'FA_ASSET_INVOICES';
469:
470: END IF;
471:
472: RETURN(TRUE);