DBA Data[Home] [Help]

APPS.JL_JLMXFGLR_XMLP_PKG dependencies on FA_BOOK_CONTROLS_MRC_V

Line 37: FA_BOOK_CONTROLS_MRC_V BKCTRL,

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

Line 786: FA_BOOK_CONTROLS_MRC_V B,

782: A.START_DATE,
783: A.END_DATE
784: INTO FROM_DATE,TO_DATE
785: FROM
786: FA_BOOK_CONTROLS_MRC_V B,
787: FA_FISCAL_YEAR A
788: WHERE A.FISCAL_YEAR = P_CURR_FY
789: AND B.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
790: AND B.FISCAL_YEAR_NAME = A.FISCAL_YEAR_NAME;

Line 957: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS_MRC_V';

953: ELSE
954: P_MRCSOBTYPE := 'P';
955: END IF;
956: IF UPPER(P_MRCSOBTYPE) = 'R' THEN
957: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS_MRC_V';
958: LP_FA_BOOKS := 'FA_BOOKS_MRC_V';
959: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS_MRC_V';
960: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS_MRC_V';
961: LP_FA_DEPRN_SUMMARY := 'FA_DEPRN_SUMMARY_MRC_V';