82:
83: IF (P_FROM_PERIOD IS NOT NULL) THEN
84: SELECT TRUNC (fadp.calendar_period_open_date)
85: INTO period_from
86: FROM fa_deprn_periods fadp
87: WHERE fadp.book_type_code = p_book_name
88: AND fadp.period_name = p_from_period;
89: END IF;
90:
91:
92: IF (P_TO_PERIOD IS NOT NULL) THEN
93: SELECT TRUNC (fadp.calendar_period_close_date)
94: INTO period_to
95: FROM fa_deprn_periods fadp
96: WHERE fadp.book_type_code = p_book_name
97: AND fadp.period_name = p_to_period;
98: END IF;
99:
172:
173: BEGIN
174: SELECT TRUNC (fadp.calendar_period_open_date)
175: INTO lp_from_date
176: FROM fa_deprn_periods fadp
177: WHERE fadp.book_type_code = p_book_name
178: AND fadp.period_name = p_from_period;
179: EXCEPTION
180: WHEN OTHERS THEN
190:
191: BEGIN
192: SELECT TRUNC (fadp.calendar_period_close_date)
193: INTO lp_to_date
194: FROM fa_deprn_periods fadp
195: WHERE fadp.book_type_code = p_book_name
196: AND fadp.period_name = p_to_period;
197: EXCEPTION
198: WHEN OTHERS THEN