DBA Data[Home] [Help]

APPS.FA_TOFES_YUD_ALEF_PKG dependencies on FA_ADJUSTMENTS_MRC_V

Line 64: FROM FA_ADJUSTMENTS_MRC_V

60: IF upper(P_MRCSOBTYPE) = 'R'
61: THEN
62: SELECT SUM(DECODE(DEBIT_CREDIT_FLAG, 'CR', ADJUSTMENT_AMOUNT * (-1), ADJUSTMENT_AMOUNT))
63: INTO ln_amount
64: FROM FA_ADJUSTMENTS_MRC_V
65: WHERE BOOK_TYPE_CODE = P_BOOK_NAME
66: AND ASSET_ID = p_asset_id_in
67: AND ADJUSTMENT_TYPE = 'COST'
68: AND SOURCE_TYPE_CODE = 'ADJUSTMENT'

Line 458: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS_MRC_V';

454: THEN
455: fnd_file.put_line(fnd_file.log,'R-b4 lp statementss ');
456: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS_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