SELECT period_name , gl_period_name , .... FROM pa_periods p , .... WHERE p.current_pa_period_flag = 'Y' AND ....