APPS.JL_JLMXFISR_XMLP_PKG dependencies on FA_DEPRN_PERIODS_MRC_V

Line 435: FA_DEPRN_PERIODS_MRC_V

431: MIN(PERIOD_COUNTER),
432: MAX(PERIOD_COUNTER)
433: INTO MIN_PER_COUNTER,MAX_PER_COUNTER
434: FROM
435: FA_DEPRN_PERIODS_MRC_V
436: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
437: AND FISCAL_YEAR = P_CURR_FY;
438: EXCEPTION
439: WHEN NO_DATA_FOUND THEN

Line 452: FA_DEPRN_PERIODS_MRC_V

448: SELECT
449: MAX(PERIOD_COUNTER)
450: INTO LAST_PER_COUNTER
451: FROM
452: FA_DEPRN_PERIODS_MRC_V
453: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
454: AND FISCAL_YEAR = P_CURR_FY - 1;
455: EXCEPTION
456: WHEN NO_DATA_FOUND THEN

Line 643: FA_DEPRN_PERIODS_MRC_V FDP

639: COUNT(RET.RETIREMENT_ID)
640: INTO L_HAS_RETIREMENT
641: FROM
642: FA_RETIREMENTS_MRC_V RET,
643: FA_DEPRN_PERIODS_MRC_V FDP
644: WHERE RET.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
645: AND RET.STATUS <> 'DELETED'
646: AND RET.BOOK_TYPE_CODE = FDP.BOOK_TYPE_CODE
647: AND RET.ASSET_ID = P_ASSET_ID

Line 675: FA_DEPRN_PERIODS_MRC_V DPP

671: BKS.COST
672: INTO L_COST_BEGIN_YEAR
673: FROM
674: FA_BOOKS_MRC_V BKS,
675: FA_DEPRN_PERIODS_MRC_V DPP
676: WHERE DPP.PERIOD_COUNTER = P_PERIOD_START
677: AND BKS.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
678: AND DPP.BOOK_TYPE_CODE = BKS.BOOK_TYPE_CODE
679: AND BKS.ASSET_ID = P_ASSET_ID

Line 721: FA_DEPRN_PERIODS_MRC_V FDP

717: RET.COST_RETIRED
718: INTO L_COST_RETIRED
719: FROM
720: FA_RETIREMENTS_MRC_V RET,
721: FA_DEPRN_PERIODS_MRC_V FDP
722: WHERE RET.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
723: AND RET.STATUS <> 'DELETED'
724: AND RET.BOOK_TYPE_CODE = FDP.BOOK_TYPE_CODE
725: AND RET.ASSET_ID = P_ASSET_ID

Line 1080: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS_MRC_V';

1076: IF UPPER(P_MRCSOBTYPE) = 'R' THEN
1077: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS_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';