DBA Data[Home] [Help]

APPS.JL_JLMXFIMP_XMLP_PKG dependencies on FA_BOOK_CONTROLS_MRC_V

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