APPS.PA_FORECAST_ITEMS_UTILS dependencies on GL_SETS_OF_BOOKS

Line 435: FROM gl_sets_of_books gl,

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
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: */

Line 580: gl_sets_of_books gl,

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)
584: AND imp.set_of_books_id = gl.set_of_books_id

Line 627: gl_sets_of_books gl,

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)
631: AND imp.set_of_books_id = gl.set_of_books_id

Line 732: gl_sets_of_books gl,

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
736: AND gl.period_set_name = glper.period_set_name

Line 769: gl_sets_of_books gl,

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
773: AND imp.set_of_books_id = gl.set_of_books_id