APPS.JL_JLARFEFR_XMLP_PKG dependencies on FA_DEPRN_PERIODS_MRC_V

Line 26: FA_DEPRN_PERIODS_MRC_V

22: SELECT
23: PERIOD_NAME
24: INTO C_PERIOD_FROM
25: FROM
26: FA_DEPRN_PERIODS_MRC_V
27: WHERE PERIOD_COUNTER = P_PERIOD_COUNTER_FROM
28: AND BOOK_TYPE_CODE = P_BOOK_TYPE_CODE;
29: SELECT
30: PERIOD_NAME

Line 33: FA_DEPRN_PERIODS_MRC_V

29: SELECT
30: PERIOD_NAME
31: INTO C_PERIOD_TO
32: FROM
33: FA_DEPRN_PERIODS_MRC_V
34: WHERE PERIOD_COUNTER = P_PERIOD_COUNTER_TO
35: AND BOOK_TYPE_CODE = P_BOOK_TYPE_CODE;
36: /*SRW.MESSAGE('10000'
37: ,'Check ==' || P_PERIOD_COUNTER_TO)*/NULL;

Line 45: FA_DEPRN_PERIODS_MRC_V

41: SELECT
42: 'Y'
43: INTO L_FLAG
44: FROM
45: FA_DEPRN_PERIODS_MRC_V
46: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
47: AND PERIOD_COUNTER = P_PERIOD_COUNTER_TO
48: AND PERIOD_CLOSE_DATE is not null;
49: EXCEPTION

Line 261: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS_MRC_V';

257: IF UPPER(P_MRCSOBTYPE) = 'R' THEN
258: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS_MRC_V';
259: LP_FA_BOOKS := 'FA_BOOKS_MRC_V';
260: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS_MRC_V';
261: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS_MRC_V';
262: LP_FA_DEPRN_SUMMARY := 'FA_DEPRN_SUMMARY_MRC_V';
263: LP_FA_DEPRN_DETAIL := 'FA_DEPRN_DETAIL_MRC_V';
264: ELSE
265: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS';