APPS.JL_JLMXFISR_XMLP_PKG dependencies on FA_DEPRN_PERIODS

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 490: FA_DEPRN_PERIODS

486: MIN(PERIOD_COUNTER),
487: MAX(PERIOD_COUNTER)
488: INTO MIN_PER_COUNTER,MAX_PER_COUNTER
489: FROM
490: FA_DEPRN_PERIODS
491: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
492: AND FISCAL_YEAR = P_CURR_FY;
493: EXCEPTION
494: WHEN NO_DATA_FOUND THEN

Line 507: FA_DEPRN_PERIODS

503: SELECT
504: MAX(PERIOD_COUNTER)
505: INTO LAST_PER_COUNTER
506: FROM
507: FA_DEPRN_PERIODS
508: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
509: AND FISCAL_YEAR = P_CURR_FY - 1;
510: EXCEPTION
511: 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 787: FA_DEPRN_PERIODS FDP

783: COUNT(RET.RETIREMENT_ID)
784: INTO L_HAS_RETIREMENT
785: FROM
786: FA_RETIREMENTS RET,
787: FA_DEPRN_PERIODS FDP
788: WHERE RET.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
789: AND RET.STATUS <> 'DELETED'
790: AND RET.BOOK_TYPE_CODE = FDP.BOOK_TYPE_CODE
791: AND RET.ASSET_ID = P_ASSET_ID

Line 806: FA_DEPRN_PERIODS DPP

802: BKS.COST
803: INTO L_COST_BEGIN_YEAR
804: FROM
805: FA_BOOKS BKS,
806: FA_DEPRN_PERIODS DPP
807: WHERE DPP.PERIOD_COUNTER = P_PERIOD_START
808: AND BKS.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
809: AND DPP.BOOK_TYPE_CODE = BKS.BOOK_TYPE_CODE
810: AND BKS.ASSET_ID = P_ASSET_ID

Line 865: FA_DEPRN_PERIODS FDP

861: RET.COST_RETIRED
862: INTO L_COST_RETIRED
863: FROM
864: FA_RETIREMENTS RET,
865: FA_DEPRN_PERIODS FDP
866: WHERE RET.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
867: AND RET.STATUS <> 'DELETED'
868: AND RET.BOOK_TYPE_CODE = FDP.BOOK_TYPE_CODE
869: 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';

Line 1087: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS';

1083: ELSE
1084: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS';
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);