DBA Data[Home] [Help]

APPS.PA_FORECAST_GRC_PVT dependencies on GL_DATE_PERIOD_MAP

Line 293: from gl_date_period_map p

289: ,(pglp.period_year*10000) + pglp.period_num AS PERIOD_NUM
290: FROM gl_periods pglp
291: WHERE exists
292: (select null
293: from gl_date_period_map p
294: where pglp.period_set_name = p.period_set_name
295: -- and p.period_set_name = l_period_set_name
296: and p.period_set_name = l_pa_period_set_name -- bug 3434019
297: and p.period_type = l_pa_period_type

Line 315: from gl_date_period_map g

311: ,(gglp.period_year*10000) + gglp.period_num AS PERIOD_NUM
312: FROM gl_periods gglp
313: WHERE exists
314: (select null
315: from gl_date_period_map g
316: where gglp.period_set_name = g.period_set_name
317: -- and g.period_set_name = l_period_set_name
318: and g.period_set_name = l_gl_period_set_name -- bug 3434019
319: and g.period_type = l_gl_period_type