APPS.JL_JLMXFGLR_XMLP_PKG dependencies on FA_DEPRN_PERIODS

Line 270: FA_DEPRN_PERIODS_MRC_V FDP

266: COUNT(RET.RETIREMENT_ID)
267: INTO L_HAS_RETIREMENT
268: FROM
269: FA_RETIREMENTS_MRC_V RET,
270: FA_DEPRN_PERIODS_MRC_V FDP
271: WHERE RET.BOOK_TYPE_CODE = T_BOOK_TYPE_CODE
272: AND RET.STATUS <> 'DELETED'
273: AND RET.BOOK_TYPE_CODE = FDP.BOOK_TYPE_CODE
274: AND RET.ASSET_ID = T_ASSET_ID

Line 293: FA_DEPRN_PERIODS_MRC_V DPP

289: BKS.COST
290: INTO L_COST_BEGIN_YEAR
291: FROM
292: FA_BOOKS_MRC_V BKS,
293: FA_DEPRN_PERIODS_MRC_V DPP
294: WHERE DPP.PERIOD_COUNTER = T_PERIOD_START
295: AND BKS.BOOK_TYPE_CODE = T_BOOK_TYPE_CODE
296: AND DPP.BOOK_TYPE_CODE = BKS.BOOK_TYPE_CODE
297: AND BKS.ASSET_ID = T_ASSET_ID

Line 355: FA_DEPRN_PERIODS_MRC_V FDP

351: RET.COST_RETIRED
352: INTO L_COST_RETIRED
353: FROM
354: FA_RETIREMENTS_MRC_V RET,
355: FA_DEPRN_PERIODS_MRC_V FDP
356: WHERE RET.BOOK_TYPE_CODE = T_BOOK_TYPE_CODE
357: AND RET.STATUS <> 'DELETED'
358: AND RET.BOOK_TYPE_CODE = FDP.BOOK_TYPE_CODE
359: AND RET.ASSET_ID = T_ASSET_ID

Line 422: FA_DEPRN_PERIODS FDP

418: COUNT(RET.RETIREMENT_ID)
419: INTO L_HAS_RETIREMENT
420: FROM
421: FA_RETIREMENTS RET,
422: FA_DEPRN_PERIODS FDP
423: WHERE RET.BOOK_TYPE_CODE = T_BOOK_TYPE_CODE
424: AND RET.STATUS <> 'DELETED'
425: AND RET.BOOK_TYPE_CODE = FDP.BOOK_TYPE_CODE
426: AND RET.ASSET_ID = T_ASSET_ID

Line 445: FA_DEPRN_PERIODS DPP

441: BKS.COST
442: INTO L_COST_BEGIN_YEAR
443: FROM
444: FA_BOOKS BKS,
445: FA_DEPRN_PERIODS DPP
446: WHERE DPP.PERIOD_COUNTER = T_PERIOD_START
447: AND BKS.BOOK_TYPE_CODE = T_BOOK_TYPE_CODE
448: AND DPP.BOOK_TYPE_CODE = BKS.BOOK_TYPE_CODE
449: AND BKS.ASSET_ID = T_ASSET_ID

Line 507: FA_DEPRN_PERIODS FDP

503: RET.COST_RETIRED
504: INTO L_COST_RETIRED
505: FROM
506: FA_RETIREMENTS RET,
507: FA_DEPRN_PERIODS FDP
508: WHERE RET.BOOK_TYPE_CODE = T_BOOK_TYPE_CODE
509: AND RET.STATUS <> 'DELETED'
510: AND RET.BOOK_TYPE_CODE = FDP.BOOK_TYPE_CODE
511: AND RET.ASSET_ID = T_ASSET_ID

Line 752: FA_DEPRN_PERIODS_MRC_V

748: MIN(PERIOD_COUNTER),
749: MAX(PERIOD_COUNTER)
750: INTO MIN_PER_COUNTER,MAX_PER_COUNTER
751: FROM
752: FA_DEPRN_PERIODS_MRC_V
753: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
754: AND FISCAL_YEAR = P_CURR_FY;
755: EXCEPTION
756: WHEN NO_DATA_FOUND THEN

Line 769: FA_DEPRN_PERIODS_MRC_V

765: SELECT
766: MAX(PERIOD_COUNTER)
767: INTO LAST_PER_COUNTER
768: FROM
769: FA_DEPRN_PERIODS_MRC_V
770: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
771: AND FISCAL_YEAR = P_CURR_FY - 1;
772: EXCEPTION
773: WHEN NO_DATA_FOUND THEN

Line 805: FA_DEPRN_PERIODS

801: MIN(PERIOD_COUNTER),
802: MAX(PERIOD_COUNTER)
803: INTO MIN_PER_COUNTER,MAX_PER_COUNTER
804: FROM
805: FA_DEPRN_PERIODS
806: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
807: AND FISCAL_YEAR = P_CURR_FY;
808: EXCEPTION
809: WHEN NO_DATA_FOUND THEN

Line 822: FA_DEPRN_PERIODS

818: SELECT
819: MAX(PERIOD_COUNTER)
820: INTO LAST_PER_COUNTER
821: FROM
822: FA_DEPRN_PERIODS
823: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
824: AND FISCAL_YEAR = P_CURR_FY - 1;
825: EXCEPTION
826: WHEN NO_DATA_FOUND THEN

Line 960: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS_MRC_V';

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
964: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS';

Line 967: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS';

963: ELSE
964: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS';
965: LP_FA_BOOKS := 'FA_BOOKS';
966: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS';
967: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS';
968: LP_FA_DEPRN_SUMMARY := 'FA_DEPRN_SUMMARY';
969: LP_FA_DEPRN_DETAIL := 'FA_DEPRN_DETAIL';
970: END IF;
971: RETURN (TRUE);