APPS.PER_PERSON_ANALYSES_PKG SQL Statements

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

Line: 33

select 'x'
from per_person_analyses pa
,    per_analysis_criteria ac
where pa.analysis_criteria_id = p_analysis_criteria_id
and   pa.business_group_id + 0 = p_bg_id
and   pa.analysis_criteria_id = ac.analysis_criteria_id
and   ac.id_flex_num = p_id_flex_num
and   nvl(pa.date_to,p_end_of_time) =
      nvl(p_date_to,p_end_of_time)
and   pa.date_from = p_date_from
and   pa.person_id = p_person_id
and  (p_rowid is null or
     (p_rowid is not null and
      pa.rowid <> chartorowid(p_rowid)));

Line: 55

      hr_utility.set_message(801,'HR_6012_ROW_INSERTED');

Line: 70

select per_person_analyses_s.nextval
from sys.dual;

Line: 97

   select count(customized_restriction_id)
   into   p_count_info_type
   from   pay_restriction_values
   where  restriction_code = 'INFO_TYPE'
   and    customized_restriction_id = p_customized_restriction_id;

Line: 120

    select 'X'
    from pay_legislation_rules
    where legislation_code = p_legislation_code
      and rule_type = 'OSHA'
      and rule_mode = to_char(p_id_flex_num);

Line: 127

    select 'X'
    from per_person_analyses pa,
         per_analysis_criteria ac
    where pa.business_group_id + 0 = p_business_group_id
      and pa.analysis_criteria_id = ac.analysis_criteria_id
      and ac.id_flex_num = p_id_flex_num
      and ac.segment1 = p_segment1;

Line: 185

  select 'Y'
  from per_person_analyses ppa,per_analysis_criteria pac
  where ppa.id_flex_num = p_id_flex_num
  and ppa.person_id = p_person_id
  and ppa.business_group_id = p_business_group_id
  and pac.analysis_criteria_id = ppa.analysis_criteria_id
  and pac.id_flex_num = ppa.id_flex_num;