2210: INTO l_date
2211: FROM PA_PERIODS PAP,
2212: GL_PERIOD_STATUSES GLP,
2213: PA_IMPLEMENTATIONS PAIMP,
2214: PA_LOOKUPS PAL
2215: WHERE PAP.period_name = p_period_name
2216: AND PAP.GL_PERIOD_NAME = GLP.PERIOD_NAME
2217: AND GLP.SET_OF_BOOKS_ID = PAIMP.SET_OF_BOOKS_ID
2218: AND GLP.APPLICATION_ID = Pa_Period_Process_Pkg.Application_id
2369: INTO l_date
2370: FROM PA_PERIODS PAP,
2371: GL_PERIOD_STATUSES GLP,
2372: PA_IMPLEMENTATIONS PAIMP,
2373: PA_LOOKUPS PAL
2374: WHERE PAP.period_name = p_period_name
2375: AND PAP.GL_PERIOD_NAME = GLP.PERIOD_NAME
2376: AND GLP.SET_OF_BOOKS_ID = PAIMP.SET_OF_BOOKS_ID
2377: AND GLP.APPLICATION_ID = Pa_Period_Process_Pkg.Application_id