APPS.JL_JLARFEFR_XMLP_PKG dependencies on FA_BOOK_CONTROLS

Line 20: FA_BOOK_CONTROLS_MRC_V

16: SELECT
17: DISTRIBUTION_SOURCE_BOOK
18: INTO P_CORP_BOOK
19: FROM
20: FA_BOOK_CONTROLS_MRC_V
21: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE;
22: SELECT
23: PERIOD_NAME
24: INTO C_PERIOD_FROM

Line 75: FA_BOOK_CONTROLS

71: SELECT
72: DISTRIBUTION_SOURCE_BOOK
73: INTO P_CORP_BOOK
74: FROM
75: FA_BOOK_CONTROLS
76: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE;
77: SELECT
78: PERIOD_NAME
79: INTO C_PERIOD_FROM

Line 158: FA_BOOK_CONTROLS_MRC_V BKCTRL,

154: FCURR.DESCRIPTION,
155: GSBKS.NAME
156: INTO BASE_CURR,PREC,MIN_AU,DESCR,ORG_NAME
157: FROM
158: FA_BOOK_CONTROLS_MRC_V BKCTRL,
159: FND_CURRENCIES_VL FCURR,
160: GL_SETS_OF_BOOKS GSBKS
161: WHERE BKCTRL.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
162: AND BKCTRL.SET_OF_BOOKS_ID = GSBKS.SET_OF_BOOKS_ID

Line 181: FA_BOOK_CONTROLS BKCTRL,

177: FCURR.DESCRIPTION,
178: GSBKS.NAME
179: INTO BASE_CURR,PREC,MIN_AU,DESCR,ORG_NAME
180: FROM
181: FA_BOOK_CONTROLS BKCTRL,
182: FND_CURRENCIES_VL FCURR,
183: GL_SETS_OF_BOOKS GSBKS
184: WHERE BKCTRL.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
185: AND BKCTRL.SET_OF_BOOKS_ID = GSBKS.SET_OF_BOOKS_ID

Line 258: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS_MRC_V';

254: ELSE
255: P_MRCSOBTYPE := 'P';
256: END IF;
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';

Line 265: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS';

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';
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';