APPS.JL_JLMXFIMP_XMLP_PKG dependencies on FA_BOOK_CONTROLS

Line 35: FA_BOOK_CONTROLS_MRC_V BKCTRL,

31: FCURR.MINIMUM_ACCOUNTABLE_UNIT,
32: FCURR.DESCRIPTION
33: INTO BASE_CURR,PREC,MIN_AU,DESCR
34: FROM
35: FA_BOOK_CONTROLS_MRC_V BKCTRL,
36: FND_CURRENCIES_VL FCURR,
37: GL_SETS_OF_BOOKS GSBKS
38: WHERE BKCTRL.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
39: AND BKCTRL.SET_OF_BOOKS_ID = GSBKS.SET_OF_BOOKS_ID

Line 57: FA_BOOK_CONTROLS BKCTRL,

53: FCURR.MINIMUM_ACCOUNTABLE_UNIT,
54: FCURR.DESCRIPTION
55: INTO BASE_CURR,PREC,MIN_AU,DESCR
56: FROM
57: FA_BOOK_CONTROLS BKCTRL,
58: FND_CURRENCIES_VL FCURR,
59: GL_SETS_OF_BOOKS GSBKS
60: WHERE BKCTRL.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
61: AND BKCTRL.SET_OF_BOOKS_ID = GSBKS.SET_OF_BOOKS_ID

Line 324: FA_BOOK_CONTROLS_MRC_V BK,

320: CT.NUMBER_PER_FISCAL_YEAR,
321: CEIL(CT.NUMBER_PER_FISCAL_YEAR / 2)
322: INTO V_CALENDAR_TYPE,V_PERIODS_PER_FY,V_MIDDLE_YEAR
323: FROM
324: FA_BOOK_CONTROLS_MRC_V BK,
325: FA_CALENDAR_TYPES CT
326: WHERE BK.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
327: AND CT.CALENDAR_TYPE = BK.DEPRN_CALENDAR;
328: EXCEPTION

Line 359: FA_BOOK_CONTROLS BK,

355: CT.NUMBER_PER_FISCAL_YEAR,
356: CEIL(CT.NUMBER_PER_FISCAL_YEAR / 2)
357: INTO V_CALENDAR_TYPE,V_PERIODS_PER_FY,V_MIDDLE_YEAR
358: FROM
359: FA_BOOK_CONTROLS BK,
360: FA_CALENDAR_TYPES CT
361: WHERE BK.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
362: AND CT.CALENDAR_TYPE = BK.DEPRN_CALENDAR;
363: EXCEPTION

Line 380: FA_BOOK_CONTROLS_MRC_V BC,

376: CP.START_DATE,
377: CP.END_DATE
378: INTO V_START_DATE_FISCAL_YEAR,V_END_DATE_FISCAL_YEAR,V_START_DATE,V_END_DATE
379: FROM
380: FA_BOOK_CONTROLS_MRC_V BC,
381: FA_FISCAL_YEAR FY,
382: FA_CALENDAR_PERIODS CP
383: WHERE FY.FISCAL_YEAR = P_CURR_FY
384: AND BC.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE

Line 406: FA_BOOK_CONTROLS BC,

402: CP.START_DATE,
403: CP.END_DATE
404: INTO V_START_DATE_FISCAL_YEAR,V_END_DATE_FISCAL_YEAR,V_START_DATE,V_END_DATE
405: FROM
406: FA_BOOK_CONTROLS BC,
407: FA_FISCAL_YEAR FY,
408: FA_CALENDAR_PERIODS CP
409: WHERE FY.FISCAL_YEAR = P_CURR_FY
410: AND BC.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE

Line 645: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS_MRC_V';

641: END IF;
642: /*SRW.MESSAGE(1
643: ,'New:lp_currency_code' || LP_CURRENCY_CODE)*/NULL;
644: IF UPPER(P_MRCSOBTYPE) = 'R' THEN
645: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS_MRC_V';
646: LP_FA_BOOKS := 'FA_BOOKS_MRC_V';
647: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS_MRC_V';
648: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS_MRC_V';
649: LP_FA_DEPRN_DETAIL := 'FA_DEPRN_DETAIL_MRC_V';

Line 652: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS';

648: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS_MRC_V';
649: LP_FA_DEPRN_DETAIL := 'FA_DEPRN_DETAIL_MRC_V';
650: LP_FA_DEPRN_SUMMARY := 'FA_DEPRN_SUMMARY_MRC_V';
651: ELSE
652: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS';
653: LP_FA_BOOKS := 'FA_BOOKS';
654: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS';
655: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS';
656: LP_FA_DEPRN_DETAIL := 'FA_DEPRN_DETAL';