APPS.JL_JLARFEFR_XMLP_PKG dependencies on FA_DEPRN_PERIODS

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

77: SELECT
78: PERIOD_NAME
79: INTO C_PERIOD_FROM
80: FROM
81: FA_DEPRN_PERIODS
82: WHERE PERIOD_COUNTER = P_PERIOD_COUNTER_FROM
83: AND BOOK_TYPE_CODE = P_BOOK_TYPE_CODE;
84: SELECT
85: PERIOD_NAME

Line 88: FA_DEPRN_PERIODS

84: SELECT
85: PERIOD_NAME
86: INTO C_PERIOD_TO
87: FROM
88: FA_DEPRN_PERIODS
89: WHERE PERIOD_COUNTER = P_PERIOD_COUNTER_TO
90: AND BOOK_TYPE_CODE = P_BOOK_TYPE_CODE;
91: /*SRW.MESSAGE('10000'
92: ,'Check ==' || P_PERIOD_COUNTER_TO)*/NULL;

Line 100: FA_DEPRN_PERIODS

96: SELECT
97: 'Y'
98: INTO L_FLAG
99: FROM
100: FA_DEPRN_PERIODS
101: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
102: AND PERIOD_COUNTER = P_PERIOD_COUNTER_TO
103: AND PERIOD_CLOSE_DATE is not null;
104: 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';

Line 268: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS';

264: ELSE
265: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS';
266: LP_FA_BOOKS := 'FA_BOOKS';
267: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS';
268: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS';
269: LP_FA_DEPRN_SUMMARY := 'FA_DEPRN_SUMMARY';
270: LP_FA_DEPRN_DETAIL := 'FA_DEPRN_DETAIL';
271: END IF;
272: RETURN (TRUE);