APPS.PER_OBJ_BUS SQL Statements

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

Line: 15

Procedure chk_non_updateable_args(p_rec in per_obj_shd.g_rec_type) is
--
  l_proc     varchar2(72) := g_package||'chk_non_updateable_args';

Line: 61

end chk_non_updateable_args;

Line: 108

	select  business_group_id
	from	per_appraisals
	where   appraisal_id = p_appraisal_id;

Line: 284

	select  business_group_id
	from	per_all_people_f
	where   person_id = p_owning_person_id;

Line: 294

	select  'Y'
	from	per_all_people_f
	where	person_id = p_owning_person_id
	and	p_effective_date between
		effective_start_date and nvl(effective_end_date,hr_api.g_eot);

Line: 306

	select  'Y'
	from	per_appraisals
	where	appraisal_id = p_appraisal_id
	and	appraisee_person_id = p_owning_person_id;

Line: 562

      select 'Y'
      from per_appraisals appr,
           per_appraisal_templates templ
      where appr.appraisal_id = p_appraisal_id
            and appr.appraisal_template_id = templ.appraisal_template_id
            and templ.objective_asmnt_type_id is not null;

Line: 653

procedure chk_objective_delete
(p_objective_id              in      per_objectives.objective_id%TYPE
,p_object_version_number     in      per_objectives.object_version_number%TYPE
)
is
--
  l_exists		   varchar2(1);

Line: 660

  l_proc               varchar2(72)  :=  g_package||'chk_objective_delete';

Line: 667

  select 'Y'
  from   per_performance_ratings
  where  objective_id    = p_objective_id;

Line: 675

  select 'Y'
  from   per_objectives
  where  aligned_with_objective_id    = p_objective_id;

Line: 722

end chk_objective_delete;

Line: 1744

  SELECT psc.scorecard_id
  FROM   per_personal_scorecards psc
  WHERE  psc.scorecard_id = p_scorecard_id;

Line: 1843

	select  'Y'
	from	per_objectives_library
	where   objective_id = p_copied_from_lib_id;

Line: 1933

    select  'Y'
    from	per_objectives
    where   objective_id = p_copied_from_obj_id;

Line: 2027

  SELECT
    ppsc.plan_id,ppsc.scorecard_id,ppsc.person_id
  FROM
    per_objectives          pobj
   ,per_personal_scorecards ppsc
  -- ,per_perf_mgmt_plans     ppln
  WHERE
      pobj.objective_id = p_aligned_with_obj_id
  AND pobj.scorecard_id = ppsc.scorecard_id;

Line: 2039

    SELECT
      NVL(ppsc.plan_id,ap.plan_id) PLAN_ID,
      NVL(ppsc.scorecard_id,ppsc2.scorecard_id)            SCORECARD_ID,
      NVL(ppsc.person_id,ap.appraisee_person_id) SOURCE_PERSON_ID
    FROM
      per_objectives          pobj
     ,per_personal_scorecards ppsc
     ,per_personal_scorecards ppsc2
     ,per_appraisals ap
     WHERE
        pobj.objective_id = p_aligned_with_obj_id
    AND pobj.scorecard_id = ppsc.scorecard_id (+)
    AND pobj.appraisal_id = ap.appraisal_id (+)
    AND ap.plan_id = ppsc2.plan_id(+)
    AND ap.appraisee_person_id = ppsc2.person_id(+);

Line: 2063

  SELECT
    plan_id,person_id
  FROM
    per_personal_scorecards
  WHERE
    scorecard_id = p_scorecard_id;

Line: 2077

  SELECT 'Y'
  FROM
    per_objectives          pobj
   ,per_personal_scorecards ppsc
   ,per_perf_mgmt_plans     ppln
  WHERE
       ppln.plan_id      = l_source_plan_id
  AND  ppln.plan_id      = ppsc.plan_id
  AND  ppsc.person_id    = l_source_person_id
  AND  pobj.objective_id = p_aligned_with_obj_id;

Line: 2094

  SELECT
    'Y'
  FROM
    per_scorecard_sharing
  WHERE
    scorecard_id = l_source_scorecard_id
  AND person_id  = l_target_person_id;

Line: 2525

Procedure insert_validate(p_rec in per_obj_shd.g_rec_type
			 ,p_effective_date in date
                         ,p_weighting_over_100_warning   out nocopy boolean
                         ,p_weighting_appraisal_warning  out nocopy boolean
                         ) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 2787

End insert_validate;

Line: 2792

Procedure update_validate(p_rec in per_obj_shd.g_rec_type
			 ,p_effective_date in date
                         ,p_weighting_over_100_warning   out nocopy boolean
                         ,p_weighting_appraisal_warning  out nocopy boolean
                         ) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 2818

  chk_non_updateable_args(p_rec	=> p_rec);

Line: 3055

End update_validate;

Line: 3060

Procedure delete_validate(p_rec in per_obj_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 3069

  per_obj_bus.chk_objective_delete
  (p_objective_id              =>	p_rec.objective_id
  ,p_object_version_number     =>	p_rec.object_version_number
  );

Line: 3074

End delete_validate;

Line: 3086

          select legislation_code
          from   per_business_groups  pbg,
                 per_objectives  ppa
          where  ppa.objective_id = p_objective_id
            and  pbg.business_group_id  = ppa.business_group_id;