APPS.PA_BUDGET_ATTR_UPGR_PKG dependencies on GL_SETS_OF_BOOKS

Line 94: l_GL_period_type gl_sets_of_books.accounted_period_type%TYPE := NULL;

90:
91: l_project_start_date pa_projects_all.start_date%TYPE := NULL;
92: l_org_id pa_projects_all.org_id%TYPE := NULL;
93: l_PA_period_type pa_implementations_all.pa_period_type%TYPE := NULL;
94: l_GL_period_type gl_sets_of_books.accounted_period_type%TYPE := NULL;
95:
96: -- End Bug 3804286, 12-AUG-04, jwhite --------------------------------------------
97:
98: l_uncategorized_flag pa_resource_lists_all_bg.uncategorized_flag%TYPE; -- Bug 3935863

Line 301: , gl_sets_of_books sob

297:
298: SELECT sob.accounted_period_type
299: INTO l_GL_period_type
300: FROM pa_implementations_all I
301: , gl_sets_of_books sob
302: WHERE nvl(i.org_id,-99) = l_org_id
303: AND sob.set_of_books_id = i.set_of_books_id;
304:
305: SELECT gl.PERIOD_NAME

Line 309: , gl_sets_of_books sob

305: SELECT gl.PERIOD_NAME
306: INTO l_curr_plan_period
307: FROM gl_periods gl
308: , pa_implementations_all i
309: , gl_sets_of_books sob
310: WHERE nvl(i.org_id,-99) = l_org_id
311: AND gl.period_type = l_GL_period_type
312: and l_project_start_date between gl.START_DATE and gl.END_DATE
313: AND sob.set_of_books_id = i.set_of_books_id

Line 354: , gl_sets_of_books sob

350: SELECT gl.PERIOD_NAME
351: INTO l_curr_plan_period
352: FROM gl_periods gl
353: , pa_implementations_all i
354: , gl_sets_of_books sob
355: WHERE nvl(i.org_id,-99) = l_org_id
356: AND gl.period_type = l_PA_period_type
357: and l_project_start_date between gl.START_DATE and gl.END_DATE
358: AND sob.set_of_books_id = i.set_of_books_id