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: */
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
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
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
734: AND imp.set_of_books_id = gl.set_of_books_id
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
766: AND imp.set_of_books_id = gl.set_of_books_id