64: SELECT
65: START_DATE
66: INTO INPUT_PERIOD_START_DATE
67: FROM
68: GL_PERIOD_STATUSES
69: WHERE APPLICATION_ID = 101
70: AND SET_OF_BOOKS_ID = VSET_OF_BOOKS_ID
71: AND PERIOD_NAME = P_START_PERIOD;
72: INPUT_PERIOD_START_DATE1 := TO_CHAR(TO_DATE(INPUT_PERIOD_START_DATE,L_DT_FMT),L_DT_FMT2);
73: SELECT
74: END_DATE
75: INTO INPUT_PERIOD_END_DATE
76: FROM
77: GL_PERIOD_STATUSES
78: WHERE APPLICATION_ID = 101
79: AND SET_OF_BOOKS_ID = VSET_OF_BOOKS_ID
80: AND PERIOD_NAME = P_END_PERIOD;
81: INPUT_PERIOD_END_DATE1 :=to_char(TO_DATE(INPUT_PERIOD_END_DATE,L_DT_FMT),L_DT_FMT2);