eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FORECAST_ITEMS_UTILS dependencies on GL_PERIODS

Line 581: gl_periods glper,

577: glper.period_name
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

Line 628: gl_periods glper,

624: BULK COLLECT
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

Line 731: gl_periods glper,

727: BULK COLLECT
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

Line 763: gl_periods glper,

759: BULK COLLECT
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