APPS.PA_FORECAST_GRC_PVT SQL Statements

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

Line: 73

/* SELECT EFFECTIVE_START_DATE,EFFECTIVE_END_DATE
 FROM    per_assignments_f
 WHERE  person_id = p_person_id
 AND    organization_id = p_org_id
 AND (((EFFECTIVE_END_DATE BETWEEN p_start_date AND p_end_date) OR
     (EFFECTIVE_START_DATE   BETWEEN p_start_date AND p_end_date))
     OR ((p_start_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE)OR
        (p_end_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE)));

Line: 83

SELECT RESOURCE_EFFECTIVE_START_DATE, RESOURCE_EFFECTIVE_END_DATE
FROM pa_resources_denorm
WHERE person_id = p_person_id
 AND   resource_organization_id = p_org_id
AND (((RESOURCE_EFFECTIVE_END_DATE BETWEEN p_start_date AND p_end_date) OR
     (RESOURCE_EFFECTIVE_START_DATE   BETWEEN p_start_date AND p_end_date))
     OR ((p_start_date BETWEEN RESOURCE_EFFECTIVE_START_DATE AND RESOURCE_EFFECTIVE_END_DATE)OR
        (p_end_date BETWEEN RESOURCE_EFFECTIVE_START_DATE AND RESOURCE_EFFECTIVE_END_DATE)));

Line: 102

   SELECT resource_id
   INTO	  l_resource_id
   FROM   pa_resource_txn_attributes
   WHERE  person_id = p_person_id;

Line: 283

 SELECT
         pglp.period_name             AS  PERIOD_NAME
        ,pglp.start_date              AS  PERIOD_START_DATE
        ,pglp.end_date                AS  PERIOD_END_DATE
        ,pglp.period_year             AS  PERIOD_YEAR
        ,pglp.quarter_num             AS  PERIOD_QUARTER
        ,(pglp.period_year*10000) + pglp.period_num AS PERIOD_NUM
  FROM   gl_periods                      pglp
  WHERE exists
        (select null
         from gl_date_period_map p
         where pglp.period_set_name = p.period_set_name
  --       and   p.period_set_name = l_period_set_name
         and   p.period_set_name = l_pa_period_set_name  -- bug 3434019
         and   p.period_type = l_pa_period_type
         and   pglp.period_name = p.period_name)
    AND p_run_end_date  >= pglp.start_date
    AND p_run_start_date <= pglp.end_date
;

Line: 305

 SELECT
         gglp.period_name             AS  PERIOD_NAME
        ,gglp.start_date              AS  PERIOD_START_DATE
        ,gglp.end_date                AS  PERIOD_END_DATE
        ,gglp.period_year             AS  PERIOD_YEAR
        ,gglp.quarter_num             AS  PERIOD_QUARTER
        ,(gglp.period_year*10000) + gglp.period_num AS PERIOD_NUM
  FROM  gl_periods                      gglp
  WHERE exists
        (select null
         from gl_date_period_map g
         where gglp.period_set_name = g.period_set_name
--         and   g.period_set_name = l_period_set_name
         and   g.period_set_name = l_gl_period_set_name    -- bug 3434019
         and   g.period_type = l_gl_period_type
         and   gglp.period_name = g.period_name)
    AND p_run_start_date <= gglp.end_date
    AND p_run_end_date  >= gglp.start_date
;

Line: 326

  SELECT
         period_year                            AS PERIOD_YEAR
        ,mon_or_qtr                             AS PERIOD_MONTH
        ,ge_week_dt                             AS GE_DATE
        ,period_start_date                      AS PERIOD_START_DATE
  FROM  pa_rep_periods_v
  WHERE period_type = 'GE'
  AND   p_run_start_date <= ge_week_dt
  AND   p_run_end_date >= period_start_date
  AND   to_number(to_char(ge_week_dt,'YYYY')) = period_year
  ;

Line: 360

        x_resource_capacity_tab.delete;

Line: 361

        x_exp_orgz_id_tab.delete;

Line: 362

        x_person_id_tab.delete;

Line: 363

        x_period_type_tab.delete;

Line: 364

        x_period_name_tab.delete;

Line: 365

        x_global_exp_date_tab.delete;

Line: 366

        x_period_year_tab.delete;

Line: 367

        x_qm_number_tab.delete;

Line: 368

        x_period_num_tab.delete;

Line: 429

          	  select  bal.period_balance
            	into  l_period_balance
            	from  pa_objects       obj,
       	              pa_summ_balances bal
  	          where   obj.object_id = bal.object_id
  	          and     bal.version_id = -1
  	          and     bal.object_type_code = PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C
  	          and     bal.period_type = l_pa_period_type
  	--        and     bal.period_set_name = l_period_set_name
  	          and     bal.period_set_name = l_pa_period_set_name         -- bug 3434019
  	          and     bal.period_name = pa_periods_cur_rec.PERIOD_NAME
  	          and     bal.global_exp_period_end_date = PA_REP_UTIL_GLOB.G_DUMMY_DATE_C
  	          and     bal.amount_type_id = PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id
  	          and     obj.object_type_code = PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C
  	          and     obj.balance_type_code = l_balance_type_code
 	          and     obj.project_org_id = -1
  	          and     obj.project_organization_id = -1
  	          and     obj.project_id = -1
  	          and     obj.task_id = -1
  	          and     obj.expenditure_org_id = l_OU_id
  	          and     obj.expenditure_organization_id = l_exp_orgz_id
  	          and     obj.person_id = l_person_id
  	          and     obj.assignment_id = -1
  	          and     obj.work_type_id = -1
  	          and     obj.org_util_category_id = -1
  	          and     obj.res_util_category_id = -1
  	             for update of bal.object_id;

Line: 523

                  select  bal.period_balance
                    into  l_period_balance
                    from  pa_objects       obj,
                          pa_summ_balances bal
                  where   obj.object_id = bal.object_id
  	          and     bal.version_id = -1
  	          and     bal.object_type_code = PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C
	          and     bal.period_type = l_gl_period_type
--  	          and     bal.period_set_name = l_period_set_name
  	          and     bal.period_set_name = l_gl_period_set_name  -- bug 3434019
  	          and     bal.period_name = gl_periods_cur_rec.PERIOD_NAME
  	          and     bal.global_exp_period_end_date = PA_REP_UTIL_GLOB.G_DUMMY_DATE_C
  	          and     bal.amount_type_id = PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id
  	          and     obj.object_type_code = PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C
  	          and     obj.balance_type_code = l_balance_type_code
 	          and     obj.project_org_id = -1
  	          and     obj.project_organization_id = -1
  	          and     obj.project_id = -1
  	          and     obj.task_id = -1
  	          and     obj.expenditure_org_id = l_OU_id
  	          and     obj.expenditure_organization_id = l_exp_orgz_id
  	          and     obj.person_id = l_person_id
  	          and     obj.assignment_id = -1
  	          and     obj.work_type_id = -1
  	          and     obj.org_util_category_id = -1
  	          and     obj.res_util_category_id = -1
  	             for update of bal.object_id;

Line: 618

                  select  bal.period_balance
                    into  l_period_balance
                    from  pa_objects       obj,
                          pa_summ_balances bal
                  where   obj.object_id = bal.object_id
  	          and     bal.version_id = -1
  	          and     bal.object_type_code = PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C
  	          and     bal.period_type = 'GE'
--  	          and     bal.period_set_name = l_period_set_name
	          and     bal.period_set_name = PA_REP_UTIL_GLOB.G_DUMMY_C    --bug 3434019
  	          and     bal.period_name = PA_REP_UTIL_GLOB.G_DUMMY_C
  	          and     bal.global_exp_period_end_date = PA_REP_UTIL_GLOB.G_DUMMY_DATE_C
  	          and     bal.amount_type_id = PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id
  	          and     obj.object_type_code = PA_REP_UTIL_GLOB.G_OBJ_TYPE_C.G_RES_C
  	          and     obj.balance_type_code = l_balance_type_code
 	          and     obj.project_org_id = -1
  	          and     obj.project_organization_id = -1
  	          and     obj.project_id = -1
  	          and     obj.task_id = -1
  	          and     obj.expenditure_org_id = l_OU_id
  	          and     obj.expenditure_organization_id = l_exp_orgz_id
  	          and     obj.person_id = l_person_id
  	          and     obj.assignment_id = -1
  	          and     obj.work_type_id = -1
  	          and     obj.org_util_category_id = -1
  	          and     obj.res_util_category_id = -1
  	             for update of bal.object_id;

Line: 684

      x_resource_capacity_tab.delete;

Line: 685

      x_exp_orgz_id_tab.delete;

Line: 686

      x_person_id_tab.delete;

Line: 687

      x_period_type_tab.delete;

Line: 688

      x_period_name_tab.delete;

Line: 689

      x_global_exp_date_tab.delete;

Line: 690

      x_period_year_tab.delete;

Line: 691

      x_qm_number_tab.delete;

Line: 692

      x_period_num_tab.delete;