[Home] [Help]
361: SELECT
362: TRUNC(START_DATE)
363: INTO L_START_DATE
364: FROM
365: GL_PERIOD_STATUSES
366: WHERE APPLICATION_ID = 200
367: AND NVL(ADJUSTMENT_PERIOD_FLAG
368: ,'N') = 'N'
369: AND TRUNC(P_CUT_DATE) between START_DATE
564: SELECT
565: TRUNC(START_DATE)
566: INTO L_START_DATE
567: FROM
568: GL_PERIOD_STATUSES
569: WHERE APPLICATION_ID = 200
570: AND NVL(ADJUSTMENT_PERIOD_FLAG
571: ,'N') = 'N'
572: AND TRUNC(P_CUT_DATE) between START_DATE