Previous  Next          Contents  Index  Navigation  Glossary  Library

Determining PA and GL Periods

You should define your view to set the PA period and GL period to the current reporting period. To do this, include this statement in your view:

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


         Previous  Next          Contents  Index  Navigation  Glossary  Library