APPS.PER_SSL_BUS SQL Statements

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

Line: 119

    select null
    from   per_salary_surveys pss
    where  pss.salary_survey_id = p_salary_survey_id;

Line: 225

    select null
    from   per_salary_survey_lines
    where  p_start_date              = start_date
    and    survey_job_name_code      = p_survey_job_name_code
    and    nvl(survey_region_code,hr_api.g_varchar2)
                                     = nvl(p_survey_region_code,hr_api.g_varchar2)
    and    nvl(survey_seniority_code,hr_api.g_varchar2)
                                     = nvl(p_survey_seniority_code,hr_api.g_varchar2)
    and    nvl(company_size_code,hr_api.g_varchar2)
                                     = nvl(p_company_size_code,hr_api.g_varchar2)
    and    nvl(industry_code,hr_api.g_varchar2)
                                     = nvl(p_industry_code,hr_api.g_varchar2)
    and    nvl(survey_age_code,hr_api.g_varchar2)
                                     = nvl(p_survey_age_code,hr_api.g_varchar2)    and    salary_survey_line_id <> nvl(p_salary_survey_line_id,hr_api.g_number)
    and    salary_survey_id = nvl(p_salary_survey_id,hr_api.g_number);

Line: 242

    select null
    from   per_salary_survey_lines
    where  p_start_date          <= nvl(end_date,l_eot)
    and    nvl(p_end_date,l_eot) >= start_date
    and    survey_job_name_code  = p_survey_job_name_code
    and    nvl(survey_region_code,hr_api.g_varchar2)
                                 = nvl(p_survey_region_code,hr_api.g_varchar2)
    and    nvl(survey_seniority_code,hr_api.g_varchar2)
                                 = nvl(p_survey_seniority_code,hr_api.g_varchar2)
    and    nvl(company_size_code,hr_api.g_varchar2)
                                 = nvl(p_company_size_code,hr_api.g_varchar2)
    and    nvl(industry_code,hr_api.g_varchar2)
                                 = nvl(p_industry_code,hr_api.g_varchar2)
    and    nvl(survey_age_code,hr_api.g_varchar2)
                                 = nvl(p_survey_age_code,hr_api.g_varchar2)
    and    end_date is not null
    and    salary_survey_line_id <> nvl(p_salary_survey_line_id,hr_api.g_number)
    and    salary_survey_id = nvl(p_salary_survey_id,hr_api.g_number);

Line: 262

    select null
    from   per_salary_survey_lines
    where  p_start_date < start_date
    and    (nvl(p_end_date,l_eot) >= start_date and
            nvl(p_end_date,l_eot) <= nvl(end_date,l_eot)
           )
    and    survey_job_name_code  = p_survey_job_name_code
    and    nvl(survey_region_code,hr_api.g_varchar2)
                                 = nvl(p_survey_region_code,hr_api.g_varchar2)
    and    nvl(survey_seniority_code,hr_api.g_varchar2)
                                 = nvl(p_survey_seniority_code,hr_api.g_varchar2)
    and    nvl(company_size_code,hr_api.g_varchar2)
                                 = nvl(p_company_size_code,hr_api.g_varchar2)
    and    nvl(industry_code,hr_api.g_varchar2)
                                 = nvl(p_industry_code,hr_api.g_varchar2)
    and    nvl(survey_age_code,hr_api.g_varchar2)
                                 = nvl(p_survey_age_code,hr_api.g_varchar2)
    and    salary_survey_line_id <> nvl(p_salary_survey_line_id,hr_api.g_number)
    and    salary_survey_id = nvl(p_salary_survey_id,hr_api.g_number);

Line: 473

    select null
    from   per_salary_surveys
    where  salary_survey_id = p_salary_survey_id
    and    identifier = SUBSTR(p_survey_job_name_code,0,2);

Line: 622

    select null
    from   per_salary_surveys
    where  salary_survey_id = p_salary_survey_id
    and    identifier = SUBSTR(p_survey_region_code,0,2);

Line: 768

    select null
    from   per_salary_surveys
    where  salary_survey_id = p_salary_survey_id
    and    identifier = SUBSTR(p_survey_seniority_code,0,2);

Line: 913

    select null
    from   per_salary_surveys
    where  salary_survey_id = p_salary_survey_id
    and    identifier = SUBSTR(p_company_size_code,0,2);

Line: 1058

    select null
    from   per_salary_surveys
    where  salary_survey_id = p_salary_survey_id
    and    identifier = SUBSTR(p_industry_code,0,2);

Line: 1207

    select null
    from   per_salary_surveys
    where  salary_survey_id = p_salary_survey_id
    and    identifier = SUBSTR(p_survey_age_code,0,2);

Line: 1905

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

Line: 1990

Procedure chk_delete(p_salary_survey_line_id in number) is
--
  l_proc     varchar2(72) := g_package||'chk_delete';

Line: 1996

    select null
    from   per_salary_survey_mappings ssm
    where  ssm.salary_survey_line_id = p_salary_survey_line_id;

Line: 2021

End chk_delete;

Line: 2051

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

Line: 2098

end chk_non_updateable_args;

Line: 2286

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

Line: 2453

End insert_validate;

Line: 2458

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

Line: 2469

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

Line: 2622

End update_validate;

Line: 2627

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

Line: 2638

  chk_delete(p_salary_survey_line_id => p_rec.salary_survey_line_id);

Line: 2642

End delete_validate;