APPS.PQH_CORPS_UTILITY SQL Statements

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

Line: 7

SELECT  --steps.sequence||'('|| point.spinal_point||')' "SEQUENCE",
        point.spinal_point,
        steps.spinal_point_id,
        steps.grade_spine_id
FROM    per_spinal_point_steps_f steps,
        per_spinal_points point
WHERE   steps.step_id = p_step_id
AND     steps.spinal_point_id = point.spinal_point_id
AND     p_eff_date BETWEEN steps.effective_start_date AND steps.effective_end_date;

Line: 38

 SELECT  increased_index
 FROM    pqh_fr_global_indices_f
 WHERE   gross_index = p_gross_index
 AND     type_of_record = 'IND' -- for indices
 AND     p_effective_date BETWEEN effective_start_date and effective_end_date;

Line: 60

  SELECT NVL(basic_salary_rate,0), currency_code
  FROM   pqh_fr_global_indices_f
  WHERE  type_of_record = 'INM'
  AND    p_effective_date BETWEEN effective_start_date AND effective_end_date;

Line: 66

      SELECT information50
      FROM   ben_copy_entity_results
      WHERE  copy_entity_txn_id = p_cet_id
      AND    table_alias = 'PGM';

Line: 73

  select Precision
  from Fnd_Currencies
  where currency_code =p_currency_code;

Line: 134

  SELECT action_date
  FROM   pqh_copy_entity_txns
  WHERE  copy_entity_txn_id = p_copy_entity_txn_id;

Line: 163

  SELECT information162, information169
  FROM   ben_copy_entity_results
  WHERE  copy_entity_txn_id = p_copy_entity_txn_id
  AND    information4 = p_business_group_id
  AND    table_alias = 'CPD';

Line: 172

SELECT 'Y'
FROM   ben_copy_entity_results
WHERE  copy_entity_txn_id = p_copy_entity_txn_id
AND    table_alias = 'CPP'
AND    copy_entity_result_id = p_plip_cer_id
AND    result_type_cd = 'DISPLAY'
AND    nvl(information104,'LINK') <> 'UNLINK';

Line: 182

SELECT 'Y'
FROM   ben_copy_entity_results
WHERE  copy_entity_txn_id = p_copy_entity_txn_id
AND    table_alias = 'COP'
AND    copy_entity_result_id = p_oipl_cer_id
AND    gs_parent_entity_result_id = p_plip_cer_id
AND    result_type_cd = 'DISPLAY'
AND    nvl(information104,'LINK') <> 'UNLINK';

Line: 224

 SELECT basic_salary_rate
 FROM   pqh_fr_global_indices_f
 WHERE  type_of_record = 'INM'
 AND    p_effective_date BETWEEN effective_start_date AND effective_end_date;

Line: 242

  SELECT NVL(cea.information9,'PQH_GSP_TASK_LIST')
  FROM   pqh_copy_entity_attribs cea
  WHERE  cea.copy_entity_txn_id = p_copy_entity_txn_id;

Line: 257

SELECT  steps.sequence,
        point.spinal_point,
        steps.spinal_point_id,
        steps.grade_spine_id,
        point.information1 "IB",
        get_increased_index(point.information1,p_effective_date) "INM"
FROM    per_spinal_point_steps_f steps,
        per_spinal_points point
WHERE   steps.step_id = p_step_id
AND     steps.spinal_point_id = point.spinal_point_id
AND     p_effective_date BETWEEN steps.effective_start_date AND steps.effective_end_date;

Line: 295

SELECT  org_information1
FROM    hr_organization_information
WHERE   organization_id = p_business_group_id
AND     org_information_context = 'FR_PQH_GROUPING_UNIT_INFO';

Line: 313

  SELECT bcer.information100,
         bcer.information101,
         bcer.information102,
         bcer.information103,
         bcer.information104,
         bcer.information105,
         bcer.information106,
         bcer.information107,
         bcer.information108
  FROM   ben_copy_entity_results bcer
  WHERE  bcer.copy_entity_txn_id = p_copy_entity_txn_id
  AND    bcer.table_alias = 'PQH_CORPS_TASK_LIST';

Line: 377

  SELECT 'Y'
  FROM   dual
  WHERE EXISTS (SELECT '1'
                FROM   per_parent_spines pps,
                       per_spinal_points psp
                WHERE  psp.information1 = p_gross_index
                AND    psp.information_category = 'FR_PQH'
                AND    psp.parent_spine_id = pps.parent_spine_id
                AND    pps.information_category = 'FR_PQH'
                AND    pps.information1 = 'L');

Line: 403

SELECT 'Y'
FROM    pqh_corps_definitions
WHERE   ben_pgm_id = p_pgm_id;

Line: 425

     SELECT 'Y'
     FROM   dual
     WHERE  EXISTS (SELECT 1
                    FROM   pqh_corps_definitions
                    WHERE  corps_definition_id = p_corps_definition_id
                    AND    nvl(primary_prof_field_id,-1) = p_field_of_prof_activity_id);

Line: 443

    SELECT 'Y'
    FROM   dual
    WHERE EXISTS (SELECT 1
                  FROM   pqh_corps_extra_info
                  WHERE  corps_definition_id = p_corps_definition_id
                  AND    information_type    = p_information_type);

Line: 478

Select Name
From   pqh_corps_definitions
Where  Corps_Definition_Id = p_corps_definition_id ;

Line: 521

Select Information263 -- Sequence Number
From   Ben_Copy_Entity_Results
Where  Copy_Entity_Result_Id = p_step_cer_id
And    Table_Alias = 'COP'
And    Copy_Entity_Txn_Id = p_copy_entity_txn_id;

Line: 529

Select Information98   -- Point Name
From   Ben_Copy_Entity_Results
Where  Copy_Entity_Txn_Id = p_copy_entity_txn_id
And    Table_Alias = 'OPT'
And    Copy_Entity_Result_id = ( select Information262    -- POINT Cer Id
                                 From   Ben_Copy_Entity_results
                                 Where  Copy_Entity_Result_id = p_step_cer_id);

Line: 564

Procedure update_or_delete_crpath ( p_crpath_cer_id        IN  Number,
                                p_effective_date       IN  Date,
                                p_dml_operation        IN Varchar2) IS

Cursor Csr_Ovn  IS
Select Object_Version_Number
From Ben_Copy_Entity_Results
Where Copy_Entity_Result_Id = p_crpath_cer_id;

Line: 579

     If p_dml_operation = 'INSERT' Then
      -- Purge record
          ben_copy_entity_results_api.delete_copy_entity_results
                   ( p_copy_entity_result_id => p_crpath_cer_id,
                     p_effective_date        => p_effective_date,
                     p_object_version_number => l_ovn);

Line: 589

         ben_copy_entity_results_api.update_copy_entity_results
                         ( p_copy_entity_result_id    => p_crpath_cer_id,
                           p_effective_date           => p_effective_date,
                           p_information104           => 'UNLINK',
                           p_object_version_number    => l_ovn,
                           p_information323           => null);

Line: 597

END update_or_delete_crpath;

Line: 605

 SELECT information5
 FROM   ben_copy_entity_results
 WHERE  copy_entity_txn_id = p_cet_id
 AND    table_alias = p_table_alias
 AND    copy_entity_result_id = p_cer_id;

Line: 628

   SELECT ben_pgm_id
     INTO l_pgm_id
     FROM pqh_corps_definitions
    WHERE corps_definition_id = p_corps_definition_id;

Line: 645

Select 'Y'
FROM     BEN_COPY_ENTITY_RESULTS
Where  Copy_Entity_txn_Id   = p_Copy_Entity_txn_Id
AND   Gs_Mirror_Src_Entity_Result_Id = p_mirror_src_entity_rslt_id
AND   Information234 = p_from_step_id -- p_from_step_id
AND   Information227 = p_to_corps_id -- to_corps_id
AND   Information228 = p_to_grade_id -- to_grade_id
AND   nvl(Information229,1) = nvl(p_to_step_id,1)
AND   copy_entity_result_id <> p_copy_entity_result_id; -- to_step_id

Line: 670

Select min(asg.effective_start_date)
from per_all_assignments_f asg
where asg.grade_ladder_pgm_id = p_career_level_id
and assignment_id = p_assignment_id;

Line: 677

Select min(asg.effective_start_date)
from per_all_assignments_f asg
where asg.grade_id  = p_career_level_id
and assignment_id = p_assignment_id;

Line: 683

Select min(spp.effective_start_date)
from per_spinal_point_placements_f spp
where assignment_id =p_assignment_id
and  step_id = p_career_level_id;

Line: 723

      SELECT psp.information1
        FROM per_spinal_point_placements_f spp,
             per_spinal_point_steps_f sps,
             per_spinal_points psp
       WHERE spp.step_id = p_step_id
         AND p_effective_date BETWEEN spp.effective_start_date
                                  AND spp.effective_end_date
         AND spp.step_id = sps.step_id
         AND p_effective_date BETWEEN sps.effective_start_date
                                  AND sps.effective_end_date
         AND sps.spinal_point_id = psp.spinal_point_id;

Line: 753

Select information52 post_style
from ben_copy_entity_results
where table_alias = 'PGM'
and copy_entity_txn_id = to_number(p_txn_id);