APPS.PER_PSS_BUS SQL Statements

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

Line: 121

    select null
    from   per_salary_surveys
    where upper(survey_name)   = upper(p_survey_name)
    and    survey_company_code = p_survey_company_code
    and    salary_survey_id <> nvl(p_salary_survey_id,hr_api.g_number);

Line: 385

    select null
    from   fnd_currencies_vl fcv
    where  fcv.currency_code = p_currency_code;

Line: 570

Procedure chk_delete(p_salary_survey_id
                               in per_salary_surveys.salary_survey_id%TYPE) is
--
  l_proc     varchar2(72) := g_package||'chk_delete';

Line: 577

         select null
         from   per_salary_survey_lines ssl
         where  ssl.salary_survey_id = p_salary_survey_id;

Line: 603

End chk_delete;

Line: 634

Procedure chk_non_updateable_args
  (p_rec             in per_pss_shd.g_rec_type,
   p_effective_date  in date
  ) is
--
  l_proc     varchar2(72) := g_package||'chk_non_updateable_args';

Line: 687

end chk_non_updateable_args;

Line: 832

Procedure insert_validate(p_rec            in per_pss_shd.g_rec_type,
                          p_effective_date in date) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 895

End insert_validate;

Line: 900

Procedure update_validate(p_rec in per_pss_shd.g_rec_type,
                          p_effective_date in date) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 912

  chk_non_updateable_args(p_rec => p_rec
  ,p_effective_date => p_effective_date);

Line: 955

End update_validate;

Line: 960

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

Line: 971

  chk_delete(p_salary_survey_id => p_rec.salary_survey_id);

Line: 974

End delete_validate;