DBA Data[Home] [Help]

APPS.JL_JLMXFGLR_XMLP_PKG dependencies on FA_ADJUSTMENTS_MRC_V

Line 576: FA_ADJUSTMENTS_MRC_V FAD

572: SELECT
573: SUM(FAD.ADJUSTMENT_AMOUNT)
574: INTO T_ACC_DEPRN_LIFE_TD
575: FROM
576: FA_ADJUSTMENTS_MRC_V FAD
577: WHERE FAD.BOOK_TYPE_CODE = T_BOOK_TYPE_CODE
578: AND FAD.ASSET_ID = T_ASSET_ID
579: AND FAD.SOURCE_TYPE_CODE = 'RETIREMENT'
580: AND FAD.ADJUSTMENT_TYPE = 'RESERVE'

Line 959: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS_MRC_V';

955: END IF;
956: IF UPPER(P_MRCSOBTYPE) = 'R' THEN
957: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS_MRC_V';
958: LP_FA_BOOKS := 'FA_BOOKS_MRC_V';
959: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS_MRC_V';
960: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS_MRC_V';
961: LP_FA_DEPRN_SUMMARY := 'FA_DEPRN_SUMMARY_MRC_V';
962: LP_FA_DEPRN_DETAIL := 'FA_DEPRN_DETAIL_MRC_V';
963: ELSE