DBA Data[Home] [Help]

APPS.PA_FORECAST_ITEMS_UTILS dependencies on GL_DATE_PERIOD_MAP

Line 582: gl_date_period_map glmaps

578: BULK COLLECT INTO x_StartDateTab,x_EndDateTab,x_PAPeriodNameTab
579: FROM pa_implementations_all imp,
580: gl_sets_of_books gl,
581: gl_periods glper,
582: gl_date_period_map glmaps
583: WHERE nvl(imp.org_id,-99) = nvl(p_org_id,-99)
584: AND imp.set_of_books_id = gl.set_of_books_id
585: AND gl.period_set_name = glper.period_set_name
586: AND imp.pa_period_type = glper.period_type

Line 629: gl_date_period_map glmaps

625: INTO x_StartDateTab,x_EndDateTab,x_PAPeriodNameTab
626: FROM pa_implementations_all imp,
627: gl_sets_of_books gl,
628: gl_periods glper,
629: gl_date_period_map glmaps
630: WHERE nvl(imp.org_id,-99) = nvl(p_org_id,-99)
631: AND imp.set_of_books_id = gl.set_of_books_id
632: AND gl.period_set_name = glper.period_set_name
633: AND imp.pa_period_type = glper.period_type

Line 771: gl_date_period_map glmaps

767: INTO x_StartDateTab,x_EndDateTab,x_PAPeriodNameTab
768: FROM pa_implementations_all imp,
769: gl_sets_of_books gl,
770: gl_periods glper,
771: gl_date_period_map glmaps
772: WHERE imp.org_id = p_org_id
773: AND imp.set_of_books_id = gl.set_of_books_id
774: AND gl.period_set_name = glper.period_set_name
775: AND gl.accounted_period_type = glper.period_type