DBA Data[Home] [Help]

APPS.JL_JLMXFISR_XMLP_PKG dependencies on FA_DEPRN_DETAIL

Line 662: FA_DEPRN_DETAIL_MRC_V FDD

658: COUNT(FDD.DEPRN_ADJUSTMENT_AMOUNT),
659: SUM(FDD.DEPRN_ADJUSTMENT_AMOUNT)
660: INTO L_HAS_RESERVE_ADJUSTMENT,L_TOTAL_DEPRN_ADJUSTMENT
661: FROM
662: FA_DEPRN_DETAIL_MRC_V FDD
663: WHERE FDD.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
664: AND FDD.ASSET_ID = P_ASSET_ID
665: AND FDD.PERIOD_COUNTER between P_PERIOD_START
666: AND P_PERIOD_END

Line 827: FA_DEPRN_DETAIL FDD

823: COUNT(FDD.DEPRN_ADJUSTMENT_AMOUNT),
824: SUM(FDD.DEPRN_ADJUSTMENT_AMOUNT)
825: INTO L_HAS_RESERVE_ADJUSTMENT,L_TOTAL_DEPRN_ADJUSTMENT
826: FROM
827: FA_DEPRN_DETAIL FDD
828: WHERE FDD.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
829: AND FDD.ASSET_ID = P_ASSET_ID
830: AND FDD.PERIOD_COUNTER between P_PERIOD_START
831: AND P_PERIOD_END

Line 1082: LP_FA_DEPRN_DETAIL := 'FA_DEPRN_DETAIL_MRC_V';

1078: LP_FA_BOOKS := 'FA_BOOKS_MRC_V';
1079: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS_MRC_V';
1080: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS_MRC_V';
1081: LP_FA_DEPRN_SUMMARY := 'FA_DEPRN_SUMMARY_MRC_V';
1082: LP_FA_DEPRN_DETAIL := 'FA_DEPRN_DETAIL_MRC_V';
1083: ELSE
1084: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS';
1085: LP_FA_BOOKS := 'FA_BOOKS';
1086: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS';

Line 1089: LP_FA_DEPRN_DETAIL := 'FA_DEPRN_DETAIL';

1085: LP_FA_BOOKS := 'FA_BOOKS';
1086: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS';
1087: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS';
1088: LP_FA_DEPRN_SUMMARY := 'FA_DEPRN_SUMMARY';
1089: LP_FA_DEPRN_DETAIL := 'FA_DEPRN_DETAIL';
1090: END IF;
1091: RETURN (TRUE);
1092: END AFTERPFORM;
1093: