640:
641: BEGIN
642: SELECT DISTINCT gl_end_date
643: INTO l_prev_accum_end_date
644: FROM pa_periods_v
645: WHERE gl_period_name = l_prev_accum_period ;
646: EXCEPTION
647: WHEN OTHERS THEN
648: x_ret_flag := 'N' ;
699: SELECT 'N'
700: INTO x_ret_flag
701: FROM dual
702: WHERE EXISTS (SELECT 'x'
703: FROM pa_periods_v
704: WHERE gl_period_name =
705: l_prev_accum_period) ;
706: EXCEPTION
707: WHEN NO_DATA_FOUND THEN