[Home] [Help]
5: SELECT
6: PERIOD_NAME
7: INTO CP_PERIOD_NAME
8: FROM
9: FA_DEPRN_PERIODS
10: WHERE PERIOD_COUNTER = P_PERIOD_COUNTER
11: AND BOOK_TYPE_CODE = P_BOOK_TYPE_CODE;
12: RETURN (1);
13: END CF_PERIODNAMEFORMULA;
107: SELECT
108: PERIOD_NAME
109: INTO CP_PERIOD_NAME
110: FROM
111: FA_DEPRN_PERIODS
112: WHERE PERIOD_COUNTER = P_PERIOD_COUNTER
113: AND BOOK_TYPE_CODE = P_BOOK_TYPE_CODE;
114: SELECT
115: CT.FISCAL_YEAR_NAME FISCAL_YEAR_NAME