APPS.PER_SSM_BUS SQL Statements

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

Line: 24

         select pbg.legislation_code
         from   per_business_groups pbg,
                per_salary_survey_mappings ssm
         where  ssm.salary_survey_mapping_id = p_salary_survey_mapping_id
         and    pbg.business_group_id = ssm.business_group_id;

Line: 73

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

Line: 123

end chk_non_updateable_args;

Line: 157

    select start_date
    from   per_salary_survey_lines ssl
    where  ssl.salary_survey_line_id = p_salary_survey_line_id;

Line: 213

    select nvl(end_date,hr_api.g_eot)
    from   per_salary_survey_lines ssl
    where  ssl.salary_survey_line_id = p_salary_survey_line_id;

Line: 268

    select 'Y'
    from   per_salary_survey_lines ssl
    where  ssl.salary_survey_line_id = p_salary_survey_line_id;

Line: 369

    select j.business_group_id, date_from, nvl(date_to,hr_api.g_eot)
    from   per_jobs j
    where  j.job_id = p_parent_id;

Line: 376

    select p.business_group_id,date_effective,
           nvl(hr_general.get_position_date_end(p.position_id),hr_general.end_of_time)
    from   hr_positions_f p
    where p.position_id = p_parent_id
    and effective_end_date = hr_general.end_of_time;

Line: 384

    select p.business_group_id,effective_start_date,
          effective_end_date
    from  per_all_assignments_f  p
    where p.assignment_id = p_parent_id
    and effective_end_date = hr_general.end_of_time;

Line: 639

    select 'Y'
    from   per_salary_survey_mappings ssm
    where  ssm.parent_id = p_parent_id
    and    ssm.parent_table_name = p_parent_table_name
    and    ssm.salary_survey_line_id = p_salary_survey_line_id
    and    ssm.grade_id = p_grade_id
    and    ssm.location_id = p_location_id
    and    ssm.company_organization_id = p_company_organization_id
    and    ssm.company_age_code = p_company_age_code;

Line: 718

    select inactive_date
    from   hr_locations loc
    where  loc.location_id = p_location_id and loc.location_use = 'HR'
    ;

Line: 810

    select g.business_group_id, g.date_from, nvl(g.date_to,hr_api.g_eot)
    from   per_grades g
    where  g.grade_id = p_grade_id;

Line: 815

    select business_group_id
    from per_salary_survey_mappings
    where salary_survey_mapping_id = p_salary_survey_mapping_id;

Line: 913

    select o.business_group_id, o.date_from, nvl(o.date_to,hr_api.g_eot)
    from   hr_all_organization_units o
    where  o.organization_id = p_company_organization_id;

Line: 918

    select business_group_id
    from per_salary_survey_mappings
    where salary_survey_mapping_id = p_salary_survey_mapping_id;

Line: 1016

    select 'Y'
    from   hr_lookups l
    where  l.lookup_code = p_company_age_code
    and    l.lookup_type = 'COMPANY_AGE'
    and    l.enabled_flag = 'Y';

Line: 1245

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

Line: 1337

End insert_validate;

Line: 1343

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

Line: 1357

  chk_non_updateable_args(p_rec);

Line: 1442

End update_validate;

Line: 1449

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

Line: 1459

End delete_validate;