APPS.PER_PERRPFP2_XMLP_PKG SQL Statements

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

Line: 23

  select  peo.first_name ||
	  decode(peo.first_name,null,null,' ') ||
          peo.last_name
  into    v_name
  from    per_all_people_f peo
  where  peo.person_id = p_person_id
  and  p_session_date between peo.effective_start_date
                       and     peo.effective_end_date;

Line: 75

    select  PBG.LEGISLATION_CODE
    into    v_legislation_code
    from     PER_BUSINESS_GROUPS PBG
    where    PBG.BUSINESS_GROUP_ID = p_business_group_id;

Line: 83

		select PBG.COST_ALLOCATION_STRUCTURE
                into   v_id_flex_num
                from   PER_BUSINESS_GROUPS PBG
                where PBG.BUSINESS_GROUP_ID = p_business_group_id;

Line: 98

		select rule_mode
		into   v_id_flex_num
		from   pay_legislation_rules
		where  legislation_code = v_legislation_code
		and    rule_type        = 'S'
		and    exists
      			(select null
       			from   FND_SEGMENT_ATTRIBUTE_VALUES
       			where  ID_FLEX_NUM = rule_mode
       			and    APPLICATION_ID = 800
       			and    ID_FLEX_CODE = 'SCL'
       			and    SEGMENT_ATTRIBUTE_TYPE = 'ASSIGNMENT'
       			and    ATTRIBUTE_VALUE = 'Y');

Line: 367

   select count(*)
   into v_detailcount
   from per_secondary_ass_statuses ast,
        per_all_assignments_f pa
 where ast.assignment_id = pa.assignment_id
 and   pa.person_id = p_person_id
 and   pa.business_group_id = p_business_group_id;

Line: 381

 select count(*)
   into v_detailcount
   from per_events pe,
        per_all_assignments_f pa
   where pe.event_or_interview = 'I'
   and   pa.person_id = p_person_id
   and   pa.business_group_id = p_business_group_id
  and   pa.assignment_id = pe.assignment_id;