APPS.GL_BUDGET_UTILS_PKG dependencies on GL_BUDGET_PERIOD_RANGES

Line 454: FROM gl_budget_period_ranges prs,

450: prs.start_period_num,
451: pre.period_year,
452: pre.end_period_name,
453: pre.end_period_num
454: FROM gl_budget_period_ranges prs,
455: gl_budget_period_ranges pre
456: WHERE prs.budget_version_id = pre.budget_version_id
457: AND prs.budget_version_id = x_budget_version_id
458: AND prs.period_year * 100000 + prs.start_period_num =

Line 455: gl_budget_period_ranges pre

451: pre.period_year,
452: pre.end_period_name,
453: pre.end_period_num
454: FROM gl_budget_period_ranges prs,
455: gl_budget_period_ranges pre
456: WHERE prs.budget_version_id = pre.budget_version_id
457: AND prs.budget_version_id = x_budget_version_id
458: AND prs.period_year * 100000 + prs.start_period_num =
459: (SELECT MIN(period_year * 100000 + start_period_num)

Line 460: FROM gl_budget_period_ranges

456: WHERE prs.budget_version_id = pre.budget_version_id
457: AND prs.budget_version_id = x_budget_version_id
458: AND prs.period_year * 100000 + prs.start_period_num =
459: (SELECT MIN(period_year * 100000 + start_period_num)
460: FROM gl_budget_period_ranges
461: WHERE budget_version_id = x_budget_version_id
462: AND open_flag = 'O')
463: AND pre.period_year * 100000 + pre.start_period_num =
464: (SELECT MAX(period_year * 100000 + start_period_num)

Line 465: FROM gl_budget_period_ranges

461: WHERE budget_version_id = x_budget_version_id
462: AND open_flag = 'O')
463: AND pre.period_year * 100000 + pre.start_period_num =
464: (SELECT MAX(period_year * 100000 + start_period_num)
465: FROM gl_budget_period_ranges
466: WHERE budget_version_id = x_budget_version_id
467: AND open_flag = 'O');
468: BEGIN
469: OPEN get_prd;