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 729: FROM pa_implementations_all imp,

725: glper.end_date,
726: glper.period_name
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

Line 761: FROM pa_implementations_all imp,

757: glper.end_date,
758: glper.period_name
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