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 732: gl_date_period_map glmaps

728: INTO x_StartDateTab,x_EndDateTab,x_PAPeriodNameTab
729: FROM pa_implementations_all imp,
730: gl_sets_of_books gl,
731: gl_periods glper,
732: gl_date_period_map glmaps
733: WHERE imp.org_id = p_org_id
734: AND imp.set_of_books_id = gl.set_of_books_id
735: AND gl.period_set_name = glper.period_set_name
736: AND gl.accounted_period_type = glper.period_type

Line 764: gl_date_period_map glmaps

760: INTO x_StartDateTab,x_EndDateTab,x_PAPeriodNameTab
761: FROM pa_implementations_all imp,
762: gl_sets_of_books gl,
763: gl_periods glper,
764: gl_date_period_map glmaps
765: WHERE imp.org_id = p_org_id
766: AND imp.set_of_books_id = gl.set_of_books_id
767: AND gl.period_set_name = glper.period_set_name
768: AND gl.accounted_period_type = glper.period_type