[Home] [Help]
46: TO_DATE(START_DATE
47: ,'DD-MM-RRRR')
48: INTO P_FIRST_DAY
49: FROM
50: GL_PERIODS
51: WHERE PERIOD_SET_NAME = P_PERIOD_SET_NAME
52: AND PERIOD_NAME = P_PERIOD_FROM;
53: SELECT
54: TO_DATE(END_DATE
54: TO_DATE(END_DATE
55: ,'DD-MM-RRRR')
56: INTO P_LAST_DAY
57: FROM
58: GL_PERIODS
59: WHERE PERIOD_SET_NAME = P_PERIOD_SET_NAME
60: AND PERIOD_NAME = P_PERIOD_TO;
61: SELECT
62: LEDGER.NAME,