[Home] [Help]
24: FCURR.MINIMUM_ACCOUNTABLE_UNIT,
25: FCURR.DESCRIPTION
26: INTO BASE_CURR,PREC,MIN_AU,DESCR
27: FROM
28: FA_BOOK_CONTROLS_MRC_V BKCTRL,
29: FND_CURRENCIES_VL FCURR,
30: GL_SETS_OF_BOOKS GSBKS
31: WHERE BKCTRL.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
32: AND BKCTRL.SET_OF_BOOKS_ID = GSBKS.SET_OF_BOOKS_ID
46: FCURR.MINIMUM_ACCOUNTABLE_UNIT,
47: FCURR.DESCRIPTION
48: INTO BASE_CURR,PREC,MIN_AU,DESCR
49: FROM
50: FA_BOOK_CONTROLS BKCTRL,
51: FND_CURRENCIES_VL FCURR,
52: GL_SETS_OF_BOOKS GSBKS
53: WHERE BKCTRL.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
54: AND BKCTRL.SET_OF_BOOKS_ID = GSBKS.SET_OF_BOOKS_ID
465: A.START_DATE,
466: A.END_DATE
467: INTO FROM_DATE,TO_DATE
468: FROM
469: FA_BOOK_CONTROLS_MRC_V B,
470: FA_FISCAL_YEAR A
471: WHERE A.FISCAL_YEAR = P_CURR_FY
472: AND B.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
473: AND B.FISCAL_YEAR_NAME = A.FISCAL_YEAR_NAME;
520: A.START_DATE,
521: A.END_DATE
522: INTO FROM_DATE,TO_DATE
523: FROM
524: FA_BOOK_CONTROLS B,
525: FA_FISCAL_YEAR A
526: WHERE A.FISCAL_YEAR = P_CURR_FY
527: AND B.BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
528: AND B.FISCAL_YEAR_NAME = A.FISCAL_YEAR_NAME;
1073: ELSE
1074: P_MRCSOBTYPE := 'P';
1075: END IF;
1076: IF UPPER(P_MRCSOBTYPE) = 'R' THEN
1077: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS_MRC_V';
1078: LP_FA_BOOKS := 'FA_BOOKS_MRC_V';
1079: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS_MRC_V';
1080: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS_MRC_V';
1081: LP_FA_DEPRN_SUMMARY := 'FA_DEPRN_SUMMARY_MRC_V';
1080: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS_MRC_V';
1081: LP_FA_DEPRN_SUMMARY := 'FA_DEPRN_SUMMARY_MRC_V';
1082: LP_FA_DEPRN_DETAIL := 'FA_DEPRN_DETAIL_MRC_V';
1083: ELSE
1084: LP_FA_BOOK_CONTROLS := 'FA_BOOK_CONTROLS';
1085: LP_FA_BOOKS := 'FA_BOOKS';
1086: LP_FA_ADJUSTMENTS := 'FA_ADJUSTMENTS';
1087: LP_FA_DEPRN_PERIODS := 'FA_DEPRN_PERIODS';
1088: LP_FA_DEPRN_SUMMARY := 'FA_DEPRN_SUMMARY';