APPS.PA_FCST_GLOBAL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 43

      SELECT end_date
      FROM pa_fcst_periods_tmp
     WHERE start_date  >= l_start_date
       order by start_date;

Line: 93

       SELECT KEY_MEMBER_ROLE_ID,
              FORECAST_CLASS_CATEGORY
         INTO l_prj_owner_display,
              l_class_display
         FROM pa_forecasting_options;

Line: 127

   /* select fnd_profile.value('PA_FORECASTING_PERIOD_TYPE')
      into l_period_type
      from dual; */

Line: 135

       SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name1
       FROM fnd_profile_options_tl
       WHERE profile_option_name='PA_FORECASTING_PERIOD_TYPE'
       AND language=userenv('LANG');

Line: 173

   SELECT period_name, start_date, end_date
     INTO l_start_period, l_start_date, l_end_date
     FROM pa_fcst_periods_tmp_v
    WHERE period_type = pa_fcst_global.Global_period_type
      AND trunc(sysdate) between start_date and end_date
      AND to_char(period_year) = to_char(sysdate,'YYYY');

Line: 189

    SELECT period_name, start_date, end_date
      INTO l_start_period, l_start_date, l_end_date
      FROM pa_fcst_periods_tmp_v
     WHERE period_type = pa_fcst_global.Global_period_type
       and start_date =
           ( SELECT max(start_date) from pa_fcst_periods_tmp_v
              WHERE period_type = pa_fcst_global.Global_period_type
                AND start_date < sysdate
           );

Line: 208

       select count(*) into org_count from pa_implementations;

Line: 211

	       SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name2
	       FROM fnd_profile_options_tl
               WHERE profile_option_name='PA_PRM_DEFAULT_CALENDAR'
	       AND language=userenv('LANG');

Line: 332

   SELECT  pr2.project_type_class_code
    INTO    l_project_type_class
        FROM    pa_projects_all pr1,
                pa_project_types_all pr2
        WHERE   pr1.project_id = p_project_id
         AND    pr2.project_type = pr1.project_type
         AND    nvl(pr1.org_id,-99)=nvl(pr2.org_id,-99);

Line: 369

   select fnd_profile.value('PA_FORECASTING_PERIOD_TYPE')
     into l_period_type
     from dual;

Line: 376

       SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name1
       FROM fnd_profile_options_tl
       WHERE profile_option_name='PA_FORECASTING_PERIOD_TYPE'
       AND language=userenv('LANG');

Line: 411

    SELECT  period_name
      INTO  x_start_period_name
      FROM  pa_fcst_periods_tmp_v
     WHERE  period_type = l_period_type
       AND  trunc(sysdate) between start_date and end_date
       AND  to_char(period_year) = to_char(sysdate,'YYYY');

Line: 423

    SELECT period_name
      INTO x_start_period_name
      FROM pa_fcst_periods_tmp_v
     WHERE period_type = pa_fcst_global.Global_period_type
       and start_date =
           ( SELECT max(start_date) from pa_fcst_periods_tmp_v
              WHERE period_type = pa_fcst_global.Global_period_type
                AND start_date < sysdate
           );

Line: 439

       select count(*) into org_count from pa_implementations;

Line: 442

	       SELECT USER_PROFILE_OPTION_NAME INTO l_user_profile_option_name2
	       FROM fnd_profile_options_tl
               WHERE profile_option_name='PA_PRM_DEFAULT_CALENDAR'
	       AND language=userenv('LANG');

Line: 519

      SELECT end_date
      FROM pa_fcst_periods_tmp_v
     WHERE period_type = l_period_type
       -- AND trunc(start_date)  >= trunc(l_start_date) -- 4874283
       AND start_date  >= trunc(l_start_date) -- 4874283
       order by start_date;

Line: 569

select organization_id
into  l_org_id
from hr_all_organization_units_tl
where name = p_organization_name
AND   language = userenv('LANG');

Line: 598

   SELECT
          Start_Date,
          End_Date
     INTO
          l_start_date,
          l_end_date
     FROM pa_fcst_periods_tmp_v
    WHERE period_name = p_start_period
      AND period_type = l_period_type;

Line: 675

      SELECT end_date
      FROM pa_fcst_periods_tmp_v
     WHERE period_type = l_period_type
       -- AND trunc(start_date)  >= trunc(l_start_date) -- 4874283
       AND start_date  >= trunc(l_start_date) -- 4874283
       order by start_date;

Line: 702

 SELECT  min(start_date),    -- Added for bug# 3620818
         max(end_date)
    INTO  ll_start_date,     -- Added for bug# 3620818
          ll_end_date
    FROM  pa_project_assignments
   WHERE  project_id = p_project_id;

Line: 711

	SELECT     min(p1.start_date),
                   max(p1.end_date)
        INTO       l_pl_start_date,
                   l_pl_end_date
        FROM       pa_fcst_periods_tmp_v p1,
                   pa_projects_all p2
        WHERE      p1.period_type = 'GL'
	/* Commented the AND condition and modified for bug #3620818
	AND        p1.start_date between p2.start_date and
                   NVL(p2.completion_date, ll_end_date) */
        AND        ( p1.start_date between nvl(p2.start_date, ll_start_date) and
                     NVL(p2.completion_date, ll_end_date)
                    OR
		     nvl(p2.start_date, ll_start_date) between p1.start_date and p1.end_date )
        AND        p2.project_id = p_project_id;

Line: 729

        SELECT    min(start_date),
                  max(end_date)
        INTO      l_pl_start_date,
                  l_pl_end_date
        FROM      pa_fcst_periods_tmp_v
        WHERE     period_type = 'PA'
        AND      (to_char(period_year) = to_char(sysdate,'YYYY')
                    OR  start_date between add_months(sysdate,-3) and
                                   add_months(sysdate,6));

Line: 744

  	SELECT 	pr2.project_type_class_code
  	INTO   	l_project_type_class
  	FROM   	pa_projects_all pr1,
   	      	pa_project_types_all pr2
 	WHERE   pr1.project_id = p_project_id
  	 AND   	pr2.project_type = pr1.project_type
         AND    nvl(pr1.org_id,-99)=nvl(pr2.org_id,-99);

Line: 774

  SELECT
          Start_Date,
          End_Date
     INTO
          l_start_date,
          l_end_date
     FROM pa_fcst_periods_tmp_v
    WHERE period_name = p_start_period
      AND period_type = l_period_type;

Line: 827

     SELECT sob.period_set_name
       FROM gl_sets_of_books sob,
            pa_implementations_all pia
      WHERE pia.set_of_books_id = sob.set_of_books_id
        AND ((mo_global.get_current_org_id is NULL AND      -- 4874283
              mo_global.check_access(pia.org_id) = 'Y')     -- 4874283
             OR                                             -- 4874283
             (mo_global.get_current_org_id is NOT NULL AND  -- 4874283
              pia.org_id = mo_global.get_current_org_id));  -- 4874283

Line: 874

select name, segment1
into   x_project_name, x_project_number
from   pa_projects_all
where  project_id = p_project_id;

Line: 879

select plan_run_date
into   x_FI_Date
from   pa_budget_versions
where  project_id = p_project_id
and    budget_type_code = 'FORECASTING_BUDGET_TYPE';

Line: 1077

     SELECT resd.resource_name
       FROM pa_resources_denorm resd,
            pa_project_parties prjp
      WHERE resd.person_id = prjp.resource_source_id
        AND prjp.project_id = p_project_id
        AND prjp.project_role_id  = pa_fcst_global.GetKeyMemberId
        AND (sysdate between resd.RESOURCE_EFFECTIVE_START_DATE and resd.RESOURCE_EFFECTIVE_END_DATE
        OR  (p_proj_start_date between resd.RESOURCE_EFFECTIVE_START_DATE and resd.RESOURCE_EFFECTIVE_END_DATE
            OR p_proj_end_date between resd.RESOURCE_EFFECTIVE_START_DATE and resd.RESOURCE_EFFECTIVE_END_DATE))
        order by resd.resource_name;

Line: 1187

		DELETE pa_fcst_periods_tmp;

Line: 1197

	INSERT INTO pa_fcst_periods_tmp
           (PERIOD_NAME,
	    START_DATE,
	     END_DATE)
        SELECT distinct
          glper.period_name,
          glper.start_date,
          glper.end_date
         FROM  pa_implementations imp,
               gl_sets_of_books gl,
               gl_periods glper,
               gl_period_statuses glpersts,
               gl_lookups prsts,
               gl_date_period_map glmaps
        WHERE imp.set_of_books_id         = gl.set_of_books_id
          AND  gl.period_set_name          = glper.period_set_name
          AND  gl.accounted_period_type    = glper.period_type
          AND  glpersts.set_of_books_id    = gl.set_of_books_id
          AND  glpersts.period_type        = glper.period_type
          AND  glpersts.period_name        = glper.period_name
          AND  glpersts.period_year        = glper.period_year
          AND  glpersts.closing_status     = prsts.lookup_code
          AND  glmaps.period_type          = glper.period_type
          AND  glmaps.period_name          = glper.period_name
          AND  glmaps.period_set_name      = glper.period_set_name
          AND  glpersts.application_id     = Pa_Period_Process_Pkg.Application_Id
          AND  prsts.lookup_code IN('C','F','N','O','P')
          AND  prsts.lookup_type ='CLOSING_STATUS';

Line: 1230

        INSERT INTO pa_fcst_periods_tmp
              (PERIOD_NAME,
               START_DATE,
               END_DATE)
        SELECT PER.PERIOD_NAME,
               PER.START_DATE,
               PER.END_DATE
          FROM PA_PERIODS_ALL PER
         WHERE ((mo_global.get_current_org_id is NULL AND       -- 4874283
                 mo_global.check_access(per.org_id) = 'Y')      -- 4874283
                OR                                              -- 4874283
                (mo_global.get_current_org_id is NOT NULL AND   -- 4874283
                 per.org_id = mo_global.get_current_org_id));   -- 4874283