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 733: gl_periods glper

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

Line 770: gl_periods glper,

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