[Home] [Help]
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
56: FCURR.DESCRIPTION,
57: GSBKS.NAME
58: INTO BASE_CURR,PREC,MIN_AU,DESCR,ORG_NAME
59: FROM
60: FA_BOOK_CONTROLS BKCTRL,
61: FND_CURRENCIES_VL FCURR,
62: GL_SETS_OF_BOOKS GSBKS
63: WHERE BKCTRL.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
64: AND BKCTRL.SET_OF_BOOKS_ID = GSBKS.SET_OF_BOOKS_ID
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;
835: A.START_DATE,
836: A.END_DATE
837: INTO FROM_DATE,TO_DATE
838: FROM
839: FA_BOOK_CONTROLS B,
840: FA_FISCAL_YEAR A
841: WHERE A.FISCAL_YEAR = P_CURR_FY
842: AND B.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
843: AND B.FISCAL_YEAR_NAME = A.FISCAL_YEAR_NAME;
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';
960: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS_MRC_V';
961: LP_FA_DEPRN_SUMMARY := 'FA_DEPRN_SUMMARY_MRC_V';
962: LP_FA_DEPRN_DETAIL := 'FA_DEPRN_DETAIL_MRC_V';
963: ELSE
964: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS';
965: LP_FA_BOOKS := 'FA_BOOKS';
966: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS';
967: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS';
968: LP_FA_DEPRN_SUMMARY := 'FA_DEPRN_SUMMARY';