APPS.PER_BIL_SHD SQL Statements

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

Line: 112

    select
	type,
	business_group_id,
	object_version_number,
	id_value,
	fk_value1,
	fk_value2,
	fk_value3,
	text_value1,
	text_value2,
	text_value3,
	text_value4,
	text_value5,
	text_value6,
        text_value7,
	num_value1,
	num_value2,
	num_value3,
	date_value1,
	date_value2,
	date_value3,
        created_by
    from	hr_summary
    where	id_value = p_id_value;

Line: 201

    select 	type,
	business_group_id,
	object_version_number,
	id_value,
	fk_value1,
	fk_value2,
	fk_value3,
	text_value1,
	text_value2,
	text_value3,
	text_value4,
	text_value5,
	text_value6,
        text_value7,
	num_value1,
	num_value2,
	num_value3,
	date_value1,
	date_value2,
	date_value3,
        created_by
    from	hr_summary
    where	id_value = p_id_value
    for	update nowait;

Line: 340

  select 'x'
  from   hr_summary
  where  (type = p_rec.type
          and p_rec.type in ('TEMPLATE','ITEM_TYPE','KEY_TYPE','RESTRICTION_TYPE')
          and text_value1 = p_rec.text_value1
          and business_group_id = p_rec.business_group_id
         )
  or     (type = p_rec.type
          and p_rec.type IN ('RESTRICTION_USAGE','VALID_KEY_TYPE','KEY_TYPE_USAGE','VALID_RESTRICTION')
          and fk_value1 = p_rec.fk_value1
          and fk_value2 = p_rec.fk_value2
          and business_group_id = p_rec.business_group_id
         )
  or     (type = p_rec.type
          and p_rec.type = 'ITEM_TYPE_USAGE'
          and fk_value1 = p_rec.fk_value1
          and text_value1 = p_rec.text_value1
          and business_group_id = p_rec.business_group_id
         )
  or     (type = p_rec.type
          and p_rec.type = 'PROCESS_RUN'
          and text_value2 = p_rec.text_value2
          and text_value1 = p_rec.text_value1
          and business_group_id = p_rec.business_group_id
         )
  or     (type = p_rec.type
          and p_rec.type = 'RESTRICTION_VALUE'
          and fk_value1 = p_rec.fk_value1
          and text_value1 = p_rec.text_value1
          and business_group_id = p_rec.business_group_id
         );

Line: 406

  select 'x'
  from   hr_lookups
  where  lookup_type = p_type
  and    lookup_code = p_code
  and    application_id = 800;

Line: 439

  select 'x'
  from   hr_summary_item_type_usage
  where  sequence_number = p_rec.num_value1
  and    business_group_id = p_rec.business_group_id
  and    template_id = p_rec.fk_value1;

Line: 547

  select rt.restriction_sql,
         rt.title
  from   hr_summary_restriction_type  rt,
         hr_summary_restriction_usage ru,
         hr_summary_valid_restriction vr
  where  vr.restriction_type_id  = rt.restriction_type_id
  and    ru.valid_restriction_id = vr.valid_restriction_id
  and    ru.restriction_usage_id = p_ru_id
  and    ru.business_group_id = p_bus_grp_id;

Line: 650

  select rt.restriction_sql
       , rt.business_group_id
  from   hr_summary_restriction_type rt,
         hr_summary_valid_restriction vr
  where  rt.restriction_type_id = vr.restriction_type_id
  and    rt.business_group_id = vr.business_group_id
  and    vr.valid_restriction_id = p_valid_restriction_id;

Line: 676

   l_stmt := 'Select rs.meaning from (' || l_stmt || ') rs where rs.value = '''||p_value ||''' ';

Line: 698

  select 'x'
  from   hr_summary
  where  id_value = p_value
  and business_group_id = p_rec.business_group_id;

Line: 753

    select rt.data_type
    from   hr_summary_restriction_type rt,
           hr_summary_valid_restriction vr,
           hr_summary_restriction_usage rtu
    where  rt.restriction_type_id = vr.restriction_type_id
    and    rt.business_group_id = vr.business_group_id
    and    vr.valid_restriction_id = rtu.valid_restriction_id
    and    rtu.restriction_usage_id = p_rec.fk_value1;

Line: 773

     select to_date(p_rec.text_value1,'YYYY/MM/DD HH24:MI:SS')
     into   l_date
     from   dual;