APPS.PA_BUDGET_ATTR_UPGR_PKG dependencies on PA_IMPLEMENTATIONS_ALL

Line 93: l_PA_period_type pa_implementations_all.pa_period_type%TYPE := NULL;

89: -- Bug 3804286, 12-AUG-04, jwhite -----------------------------------------------
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:

Line 300: FROM pa_implementations_all I

296: begin
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:

Line 308: , pa_implementations_all i

304:
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

Line 339: FROM pa_implementations_all i

335: begin
336:
337: SELECT i.pa_period_type
338: INTO l_PA_period_type
339: FROM pa_implementations_all i
340: WHERE nvl(i.org_id,-99) = l_org_id;
341:
342: exception
343: WHEN OTHERS THEN

Line 353: , pa_implementations_all i

349:
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