APPS.PQH_CORPS_COPY SQL Statements

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

Line: 34

   select spt.spinal_point step_name
   into l_step_name
   from per_spinal_point_steps_f sps, per_spinal_points spt
   where sps.spinal_point_id = spt.spinal_point_id
      and sps.step_id = p_grade_step_id
and trunc(sysdate) between sps.effective_start_date and sps.effective_end_date
;

Line: 46

select grd.name
into l_grade_name
from per_spinal_point_steps_f sps, per_grade_spines_f gsp, per_grades_vl grd
where sps.grade_spine_id  = gsp.grade_spine_id
and gsp.grade_id = grd.grade_id
and sps.step_id = p_grade_step_id
and trunc(sysdate) between sps.effective_start_date and sps.effective_end_date
and trunc(sysdate) between gsp.effective_start_date and gsp.effective_end_date
;

Line: 60

select grd.grade_id
into l_grade_id
from per_spinal_point_steps_f sps, per_grade_spines_f gsp, per_grades grd
where sps.grade_spine_id  = gsp.grade_spine_id
and gsp.grade_id = grd.grade_id
and sps.step_id = p_grade_step_id
and trunc(sysdate) between sps.effective_start_date and sps.effective_end_date
and trunc(sysdate) between gsp.effective_start_date and gsp.effective_end_date
;

Line: 75

   select ghv.hierarchy_version_id hier_ver
   from per_gen_hierarchy ghr, per_gen_hierarchy_versions ghv
   where ghr.hierarchy_id = ghv.hierarchy_id
   and ghr.type ='CAREER_PATH'
   order by ghv.hierarchy_version_id;

Line: 85

      select count(*) into l_nodes
      from per_gen_hierarchy_nodes
      where hierarchy_version_id = i.hier_ver;

Line: 95

procedure insert_career_path(p_effective_date           in date,
                             p_hierarchy_version_id     in number,
                             p_business_group_id        in number,
                             p_from_corps_definition_id in number,
                             p_starting_grade_step_id   in number,
                             p_ending_grade_step_id     in number,
                             p_to_corps_definition_id   in number,
                             p_from_seniority           in number default null,
                             p_from_seniority_uom       in varchar2 default null,
                             p_to_seniority             in number default null,
                             p_to_seniority_uom         in varchar2 default null,
                             p_node_id                  out nocopy number,
                             p_object_version_number    out nocopy number) is
   l_node_type varchar2(30) := 'CAREER_NODE';

Line: 110

   cursor csr_career_path is select 'X' from per_gen_hierarchy_nodes
                where entity_id = to_char(p_starting_grade_step_id)
                  and information3 = p_ending_grade_step_id
                  and information4 = p_from_corps_definition_id
                  and information9 = p_to_corps_definition_id
                  and information_category = l_node_type;

Line: 159

end insert_career_path;

Line: 160

procedure update_career_path(p_effective_date           in date,
                             p_node_id                  in number,
                             p_from_corps_definition_id in number   default null,
                             p_starting_grade_step_id   in number   default null,
                             p_ending_grade_step_id     in number   default null,
                             p_to_corps_definition_id   in number   default null,
                             p_from_seniority           in number   default null,
                             p_from_seniority_uom       in varchar2 default null,
                             p_to_seniority             in number   default null,
                             p_to_seniority_uom         in varchar2 default null,
                             p_object_version_number    in out nocopy number
) is
   l_node_type varchar2(30) := 'CAREER_NODE';

Line: 175

   cursor csr_check is select 'X' from per_gen_hierarchy_nodes
                where hierarchy_node_id = p_node_id
                  and object_version_number = p_object_version_number;

Line: 178

   cursor csr_career_path is select 'X' from per_gen_hierarchy_nodes
                where entity_id = to_char(p_starting_grade_step_id)
                  and information3 = p_ending_grade_step_id
                  and information4 = p_from_corps_definition_id
                  and information9 = p_to_corps_definition_id
                  and information_category = l_node_type
                  and hierarchy_node_id <> p_node_id;

Line: 232

end update_career_path;

Line: 233

procedure delete_career_path(p_node_id               in number,
                             p_object_version_number in number) is
   cursor csr_career_path is select 'X' from per_gen_hierarchy_nodes
                             where hierarchy_node_id = p_node_id
                             and object_version_number = p_object_version_number;

Line: 251

end delete_career_path;

Line: 264

procedure delete_corps_fileres(p_corps_definition_id     in number,
                               p_filere_cd              in varchar2 default null) is
begin
      NULL;

Line: 268

end delete_corps_fileres;

Line: 270

procedure delete_corps(p_corps_definition_id     in number) is
begin
  NULL;

Line: 273

end delete_corps;

Line: 275

procedure delete_corps_grade(p_corps_definition_id     in number,
                             p_grade_id                in number) is
begin
   NULL;

Line: 279

end delete_corps_grade;