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 PA_IMPLEMENTATIONS_ALL

Line 432: /* Commented for bug 3434019. Period_set_name will be fetched from pa_implementations_all based on OU.

428: return '-99';
429: else
430: BEGIN
431:
432: /* Commented for bug 3434019. Period_set_name will be fetched from pa_implementations_all based on OU.
433: SELECT gl.period_set_name
434: INTO lv_period_set_name
435: FROM gl_sets_of_books gl,
436: pa_implementations_all imp

Line 436: pa_implementations_all imp

432: /* Commented for bug 3434019. Period_set_name will be fetched from pa_implementations_all based on OU.
433: SELECT gl.period_set_name
434: INTO lv_period_set_name
435: FROM gl_sets_of_books gl,
436: pa_implementations_all imp
437: WHERE imp.set_of_books_id=gl.set_of_books_id
438: AND nvl(imp.org_id,-99) = nvl(p_org_id,-99);
439: */
440: --R12: MOAC Changes: Bug 4363092: Removed nvl usage with org_id

Line 443: FROM pa_implementations_all imp

439: */
440: --R12: MOAC Changes: Bug 4363092: Removed nvl usage with org_id
441: SELECT imp.period_set_name
442: INTO lv_period_set_name
443: FROM pa_implementations_all imp
444: WHERE imp.org_id = p_org_id;
445:
446: EXCEPTION
447: WHEN NO_DATA_FOUND THEN

Line 579: FROM pa_implementations_all imp,

575: SELECT glper.start_date,
576: glper.end_date,
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)

Line 626: FROM pa_implementations_all imp,

622: glper.end_date,
623: glper.period_name
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)

Line 731: FROM pa_implementations_all imp,

727: BULK COLLECT
728: INTO x_StartDateTab,
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

Line 768: FROM pa_implementations_all imp,

764: glper.end_date,
765: glper.period_name
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