APPS.HXC_TIMECARD_PROPERTIES SQL Statements

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

Line: 44

select application_column_name
  from fnd_descr_flex_column_usages
 where descriptive_flexfield_name = 'OTC PREFERENCES'
   and descriptive_flex_context_code = p_cc
   and end_user_column_name = p_sn
   and application_id = 809;

Line: 93

  g_property_definitions(8).property_name := 'TcWDeleteAllowTimecardDeleteAllowed';

Line: 221

  g_property_definitions(65).column_name := 'ATTRIBUTE2';--find_segment('TS_PER_VALIDATE_ON_SAVE','DELETE_BLANK_ROWS_ON_SAVE');--

Line: 222

  g_property_definitions(65).property_name :=  'TsPerDeleteBlankRowsOnSave';

Line: 288

  elsif(p_context_code = 'TC_W_DELETE_ALLOW') then
    p_start_index := 8;

Line: 472

      select asg.assignment_id,
             asg.assignment_number,
             asg.effective_start_date,
             asg.effective_end_date,
             nvl(ast.per_system_status,'NoSystemStatus') assignment_status_type
        from per_all_assignments_f asg,
             per_assignment_status_types ast
       where asg.person_id = p_pid
         and asg.assignment_type in ('E','C')
         and asg.primary_flag = 'Y'
         and asg.assignment_status_type_id = ast.assignment_status_type_id;

Line: 502

    SELECT employee_id
      INTO l_user_person_id
      FROM fnd_user
     WHERE user_id = fnd_global.user_id;

Line: 681

  select rp.period_type
        ,rp.duration_in_days
        ,substr(fnd_date.date_to_canonical(rp.start_date),1,50) start_date
   from  hxc_recurring_periods rp
  where  rp.recurring_period_id = p_recurring_period_id;

Line: 689

  select number_per_fiscal_year
    from per_time_period_types
   where period_type = p_type;

Line: 774

  select distinct full_name, effective_start_date, effective_end_date
    from per_all_people_f
   where person_id = p_pid;

Line: 803

  select ty.reference_object
    from hxc_alias_types ty, hxc_alias_definitions ad
   where ad.alias_definition_id = p_id
     and ty.alias_type_id = ad.alias_type_id;

Line: 861

select min(effective_start_date)
  into l_date
  from per_all_assignments_f
 where person_id = p_resource_id;

Line: 1004

g_property_definitions.delete;

Line: 1007

g_period_list_cache.delete;

Line: 1215

select replace(initcap(replace(descriptive_flex_context_code,'_',' ')),' ')
      ||replace(initcap(replace(end_user_column_name,'_',' ')),' ') property_name
 from fnd_descr_flex_column_usages
 where descriptive_flexfield_name = 'OTC PREFERENCES'
   and descriptive_flex_context_code = p_code
   and application_column_name = 'ATTRIBUTE'||to_char(p_segment)
   and application_id = 809;