APPS.PER_QH_TIMELINE SQL Statements

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

Line: 29

  l_select_stmt varchar2(20000);

Line: 56

   l_sub_query:='select USER_PERSON_TYPE from per_person_types_tl where
  language=userenv(''LANG'') and PERSON_TYPE_ID=:1';

Line: 65

  'select meaning from hr_lookups
   where lookup_type=''YES_NO''
   and enabled_flag=''Y''
   and '||l_date_string||' between nvl(start_date_active,'||l_date_string||')
   and nvl(end_date_active,'||l_date_string||') and lookup_code=:1';

Line: 75

  'select meaning from hr_lookups
   where lookup_type=''BLOOD_TYPE''
   and enabled_flag=''Y''
   and '||l_date_string||' between nvl(start_date_active,'||l_date_string||')
   and nvl(end_date_active,'||l_date_string||') and lookup_code=:1';

Line: 85

    'select description
    from fnd_languages_vl
    where language_code=:1';

Line: 93

  'select meaning from hr_lookups
   where lookup_type=''HOME_OFFICE''
   and enabled_flag=''Y''
   and '||l_date_string||' between nvl(start_date_active,'||l_date_string||')
   and nvl(end_date_active,'||l_date_string||') and lookup_code=:1';

Line: 103

  'select meaning from hr_lookups
   where lookup_type=''MAR_STATUS''
   and enabled_flag=''Y''
   and '||l_date_string||' between nvl(start_date_active,'||l_date_string||')
   and nvl(end_date_active,'||l_date_string||') and lookup_code=:1';

Line: 113

  'select meaning from hr_lookups
   where lookup_type=''NATIONALITY''
   and enabled_flag=''Y''
   and '||l_date_string||' between nvl(start_date_active,'||l_date_string||')
   and nvl(end_date_active,'||l_date_string||') and lookup_code=:1';

Line: 123

  'select meaning from hr_lookups
   where lookup_type=''YES_NO''
   and enabled_flag=''Y''
   and '||l_date_string||' between nvl(start_date_active,'||l_date_string||')
   and nvl(end_date_active,'||l_date_string||') and lookup_code=:1';

Line: 133

  'select meaning from hr_lookups
   where lookup_type=''YES_NO''
   and enabled_flag=''Y''
   and '||l_date_string||' between nvl(start_date_active,'||l_date_string||')
   and nvl(end_date_active,'||l_date_string||') and lookup_code=:1';

Line: 146

  'select meaning from hr_lookups
   where lookup_type=''REGISTERED_DISABLED''
   and enabled_flag=''Y''
   and '||l_date_string||' between nvl(start_date_active,'||l_date_string||')
   and nvl(end_date_active,'||l_date_string||') and lookup_code=:1';

Line: 159

  'select meaning from hr_lookups
   where lookup_type=''YES_NO''
   and enabled_flag=''Y''
   and '||l_date_string||' between nvl(start_date_active,'||l_date_string||')
   and nvl(end_date_active,'||l_date_string||') and lookup_code=:1';

Line: 169

  'select meaning from hr_lookups
   where lookup_type=''SEX''
   and enabled_flag=''Y''
   and '||l_date_string||' between nvl(start_date_active,'||l_date_string||')
   and nvl(end_date_active,'||l_date_string||') and lookup_code=:1';

Line: 179

  'select meaning from hr_lookups
   where lookup_type=''STUDENT_STATUS''
   and enabled_flag=''Y''
   and '||l_date_string||' between nvl(start_date_active,'||l_date_string||')
   and nvl(end_date_active,'||l_date_string||') and lookup_code=:1';

Line: 189

  'select meaning from hr_lookups
   where lookup_type=''TITLE''
   and enabled_flag=''Y''
   and '||l_date_string||' between nvl(start_date_active,'||l_date_string||')
   and nvl(end_date_active,'||l_date_string||') and lookup_code=:1';

Line: 199

  'select meaning from hr_lookups
   where lookup_type=''WORK_SCHEDULE''
   and enabled_flag=''Y''
   and '||l_date_string||' between nvl(start_date_active,'||l_date_string||')
   and nvl(end_date_active,'||l_date_string||') and lookup_code=:1';

Line: 209

  'select meaning from hr_lookups
   where lookup_type=''YES_NO''
   and enabled_flag=''Y''
   and '||l_date_string||' between nvl(start_date_active,'||l_date_string||')
   and nvl(end_date_active,'||l_date_string||') and lookup_code=:1';

Line: 219

  'select meaning from hr_lookups
   where lookup_type=''YES_NO''
   and enabled_flag=''Y''
   and '||l_date_string||' between nvl(start_date_active,'||l_date_string||')
   and nvl(end_date_active,'||l_date_string||') and lookup_code=:1';

Line: 229

  'select meaning from hr_lookups
   where lookup_type=''YES_NO''
   and enabled_flag=''Y''
   and '||l_date_string||' between nvl(start_date_active,'||l_date_string||')
   and nvl(end_date_active,'||l_date_string||') and lookup_code=:1';

Line: 239

    'select name
    from  ben_benfts_grp
    where benfts_grp_id=:1';

Line: 263

                  ,'MAINTAIN.RESUME_LAST_UPDATED'
                  ,'MAINTAIN.SUFFIX'
                  ,'MAINTAIN.COORD_BEN_MED_PLN_NO'
                  ,'MAINTAIN.PER_ATTRIBUTE_CATEGORY'
           /*       ,'MAINTAIN.PER_ATTRIBUTE1_V' -- Commented for fix of #3211345
                  ,'MAINTAIN.PER_ATTRIBUTE2_V'
                  ,'MAINTAIN.PER_ATTRIBUTE3_V'
                  ,'MAINTAIN.PER_ATTRIBUTE4_V'
                  ,'MAINTAIN.PER_ATTRIBUTE5_V'
                  ,'MAINTAIN.PER_ATTRIBUTE6_V'
                  ,'MAINTAIN.PER_ATTRIBUTE7_V'
                  ,'MAINTAIN.PER_ATTRIBUTE8_V'
                  ,'MAINTAIN.PER_ATTRIBUTE9_V'
                  ,'MAINTAIN.PER_ATTRIBUTE10_V'
                  ,'MAINTAIN.PER_ATTRIBUTE11_V'
                  ,'MAINTAIN.PER_ATTRIBUTE12_V'
                  ,'MAINTAIN.PER_ATTRIBUTE13_V'
                  ,'MAINTAIN.PER_ATTRIBUTE14_V'
                  ,'MAINTAIN.PER_ATTRIBUTE15_V'
                  ,'MAINTAIN.PER_ATTRIBUTE16_V'
                  ,'MAINTAIN.PER_ATTRIBUTE17_V'
                  ,'MAINTAIN.PER_ATTRIBUTE18_V'
                  ,'MAINTAIN.PER_ATTRIBUTE19_V'
                  ,'MAINTAIN.PER_ATTRIBUTE20_V'
                  ,'MAINTAIN.PER_ATTRIBUTE21_V'
                  ,'MAINTAIN.PER_ATTRIBUTE22_V'
                  ,'MAINTAIN.PER_ATTRIBUTE23_V'
                  ,'MAINTAIN.PER_ATTRIBUTE24_V'
                  ,'MAINTAIN.PER_ATTRIBUTE25_V'
                  ,'MAINTAIN.PER_ATTRIBUTE26_V'
                  ,'MAINTAIN.PER_ATTRIBUTE27_V'
                  ,'MAINTAIN.PER_ATTRIBUTE28_V'
                  ,'MAINTAIN.PER_ATTRIBUTE29_V'
                  ,'MAINTAIN.PER_ATTRIBUTE30_V'*/
                  ,'MAINTAIN.PER_INFORMATION_CATEGORY'
                 /* ,'MAINTAIN.PER_INFORMATION1_V' -- Commented for fix of #3211345
                  ,'MAINTAIN.PER_INFORMATION2_V'
                  ,'MAINTAIN.PER_INFORMATION3_V'
                  ,'MAINTAIN.PER_INFORMATION4_V'
                  ,'MAINTAIN.PER_INFORMATION5_V'
                  ,'MAINTAIN.PER_INFORMATION6_V'
                  ,'MAINTAIN.PER_INFORMATION7_V'
                  ,'MAINTAIN.PER_INFORMATION8_V'
                  ,'MAINTAIN.PER_INFORMATION9_V'
                  ,'MAINTAIN.PER_INFORMATION10_V'
                  ,'MAINTAIN.PER_INFORMATION11_V'
                  ,'MAINTAIN.PER_INFORMATION12_V'
                  ,'MAINTAIN.PER_INFORMATION13_V'
                  ,'MAINTAIN.PER_INFORMATION14_V'
                  ,'MAINTAIN.PER_INFORMATION15_V'
                  ,'MAINTAIN.PER_INFORMATION16_V'
                  ,'MAINTAIN.PER_INFORMATION17_V'
                  ,'MAINTAIN.PER_INFORMATION18_V'
                  ,'MAINTAIN.PER_INFORMATION19_V'
                  ,'MAINTAIN.PER_INFORMATION20_V'
                  ,'MAINTAIN.PER_INFORMATION21_V'
                  ,'MAINTAIN.PER_INFORMATION22_V'
                  ,'MAINTAIN.PER_INFORMATION23_V'
                  ,'MAINTAIN.PER_INFORMATION24_V'
                  ,'MAINTAIN.PER_INFORMATION25_V'
                  ,'MAINTAIN.PER_INFORMATION26_V'
                  ,'MAINTAIN.PER_INFORMATION27_V'
                  ,'MAINTAIN.PER_INFORMATION28_V'
                  ,'MAINTAIN.PER_INFORMATION29_V'
                  ,'MAINTAIN.PER_INFORMATION30_V'
                  ,'MAINTAIN.PER_INFORMATION30_M'*/
                 ) then
    l_column:=substrb(p_field,10);

Line: 422

    'select full_name
    from per_all_people_f
    where person_id=:1
    and to_date('''
    ||to_char(p_effective_date,'DDMMYYYY')||
    ''',''DDMMYYYY'') between effective_start_date and effective_end_date';

Line: 433

    'select name
    from per_grades_vl
    where grade_id=:1';

Line: 441

    'select name
    from hr_all_positions_f_vl
    where position_id=:1
    and '||l_date_string||' between effective_start_date and effective_end_date';

Line: 450

    'select name
    from per_jobs_vl
    where job_id=:1';

Line: 458

    'SELECT nvl(atl.user_status,stl.user_status)
    FROM
    per_ass_status_type_amends_tl atl,
    per_ass_status_type_amends a,
    per_assignment_status_types_tl stl,
    per_assignment_status_types s
    WHERE
    s.assignment_status_type_id=:1 and
    a.assignment_status_type_id (+)=s.assignment_status_type_id and
    a.business_group_id (+) +0='||p_business_group_id||' and
    nvl(a.active_flag, s.active_flag)=''Y'' and
    a.ass_status_type_amend_id=atl.ass_status_type_amend_id (+) and
    decode(atl.language,null,''1'',atl.language)
    =decode(atl.language,null,''1'',userenv(''LANG'')) and
    s.assignment_status_type_id=stl.assignment_status_type_id and
    stl.language=userenv(''LANG'')';

Line: 479

    'select payroll_name
    from pay_all_payrolls_f
    where payroll_id=:1
    and '||l_date_string||' between effective_start_date and effective_end_date';

Line: 489

    'select location_code
    from hr_locations
    where location_id=:1';

Line: 497

    'select full_name
    from per_all_people_f
    where person_id=:1
    and '||l_date_string||' between effective_start_date and effective_end_date';

Line: 506

    'select full_name
    from per_all_people_f
    where person_id=:1
    and '||l_date_string||' between effective_start_date and effective_end_date';

Line: 515

    'select assignment_number
    from per_all_assignments_f
    where person_id=:1
    and '||l_date_string||' between effective_start_date and effective_end_date';

Line: 524

    'select name
    from per_recruitment_activities
    where recruitment_activity_id=:1';

Line: 532

    'select name
    from hr_organization_units
    where organization_id=:1';

Line: 540

    'select name
    from hr_organization_units
    where organization_id=:1';

Line: 548

    'select name
    from per_vacancies
    where vacancy_id=:1';

Line: 556

    'select name
    from per_pay_bases
    where pay_basis_id=:1';

Line: 564

  'select meaning from hr_lookups
   where lookup_type=''YES_NO''
   and enabled_flag=''Y''
   and '||l_date_string||' between nvl(start_date_active,'||l_date_string||')
   and nvl(end_date_active,'||l_date_string||') and lookup_code=:1';

Line: 575

  'select meaning from hr_lookups
   where lookup_type=''YES_NO''
   and enabled_flag=''Y''
   and '||l_date_string||' between nvl(start_date_active,'||l_date_string||')
   and nvl(end_date_active,'||l_date_string||') and lookup_code=:1';

Line: 586

  'select meaning from hr_lookups
   where lookup_type=''EMP_CAT''
   and enabled_flag=''Y''
   and '||l_date_string||' between nvl(start_date_active,'||l_date_string||')
   and nvl(end_date_active,'||l_date_string||') and lookup_code=:1';

Line: 596

  'select meaning from hr_lookups
   where lookup_type=''EMPLOYEE_CATG''
   and enabled_flag=''Y''
   and '||l_date_string||' between nvl(start_date_active,'||l_date_string||')
   and nvl(end_date_active,'||l_date_string||') and lookup_code=:1';

Line: 606

  'select meaning from hr_lookups
   where lookup_type=''FREQUENCY''
   and enabled_flag=''Y''
   and '||l_date_string||' between nvl(start_date_active,'||l_date_string||')
   and nvl(end_date_active,'||l_date_string||') and lookup_code=:1';

Line: 616

  'select meaning from hr_lookups
   where lookup_type=''QUALIFYING_UNITS''
   and enabled_flag=''Y''
   and '||l_date_string||' between nvl(start_date_active,'||l_date_string||')
   and nvl(end_date_active,'||l_date_string||') and lookup_code=:1';

Line: 626

  'select meaning from hr_lookups
   where lookup_type=''BARGAINING_UNIT_CODE''
   and enabled_flag=''Y''
   and '||l_date_string||' between nvl(start_date_active,'||l_date_string||')
   and nvl(end_date_active,'||l_date_string||') and lookup_code=:1';

Line: 636

  'select meaning from hr_lookups
   where lookup_type=''HOURLY_SALARIED_CODE''
   and enabled_flag=''Y''
   and '||l_date_string||' between nvl(start_date_active,'||l_date_string||')
   and nvl(end_date_active,'||l_date_string||') and lookup_code=:1';

Line: 646

   'select psp.spinal_point
   from per_spinal_points psp
   , per_spinal_point_steps_f psps
   where psp.spinal_point_id=psps.spinal_point_id
   and psps.step_id=:1
   and '||l_date_string||' between psps.effective_start_date
      and psps.effective_end_date';

Line: 658

  'select meaning from hr_lookups
   where lookup_type=''APL_ASSIGN_REASON''
   and enabled_flag=''Y''
   and '||l_date_string||' between nvl(start_date_active,'||l_date_string||')
   and nvl(end_date_active,'||l_date_string||') and lookup_code=:1';

Line: 668

  'select meaning from hr_lookups
   where lookup_type=''FREQUENCY''
   and enabled_flag=''Y''
   and '||l_date_string||' between nvl(start_date_active,'||l_date_string||')
   and nvl(end_date_active,'||l_date_string||') and lookup_code=:1';

Line: 678

  'select meaning from hr_lookups
   where lookup_type=''FREQUENCY''
   and enabled_flag=''Y''
   and '||l_date_string||' between nvl(start_date_active,'||l_date_string||')
   and nvl(end_date_active,'||l_date_string||') and lookup_code=:1';

Line: 688

  'select meaning from hr_lookups
   where lookup_type=''REC_TYPE''
   and enabled_flag=''Y''
   and '||l_date_string||' between nvl(start_date_active,'||l_date_string||')
   and nvl(end_date_active,'||l_date_string||') and lookup_code=:1';

Line: 698

  'select reference
   from per_contracts_f
   where contract_id=:1
   and '||l_date_string||' between effective_start_date
   and effective_end_date';

Line: 708

  'select name
   from per_collective_agreements
   where collective_agreement_id=:1';

Line: 716

  'select id_flex_structure_name
   from fnd_id_flex_structures_vl
   where id_flex_code=''CAGR''
   and   application_id=800
   and   id_flex_num=:1';

Line: 730

    'select name
    from hr_organization_units
    where organization_id=:1';

Line: 738

    'select vendor_name
     from po_vendors
     where vendor_id=:1';

Line: 746

    'select vendor_site_code
     from po_vendor_sites
     where vendor_site_id=:1';

Line: 754

    'select segment1
     from po_headers_all
     where po_header_id=:1';

Line: 762

    'select line_num
     from po_lines_all
     where po_line_id=:1';

Line: 817

    'select group_name
    from pay_people_groups
    where people_group_id=:1';

Line: 855

    'select concatenated_segments
    from hr_soft_coding_keyflex
    where soft_coding_keyflex_id=:1';

Line: 932

    l_select_stmt:='select '||l_column;

Line: 934

    l_select_stmt:='select to_char('||l_column||')';

Line: 936

    l_select_stmt:='select fnd_date.date_to_display_date('||l_column||')';

Line: 949

  l_select_stmt:=l_select_stmt||'
  ,to_char(effective_start_date,''J'')
  ,to_char(effective_end_date,''J'')
  from '||l_table||'
  where '||l_primary_key_name||' = '||l_primary_key;

Line: 957

    l_select_stmt:=l_select_stmt||'
    and effective_end_date>=
    to_date('''||to_char(p_datetrack_date,'YYYY/MM/DD')||''',''YYYY/MM/DD'')';

Line: 961

    l_select_stmt:=l_select_stmt||'
    and effective_start_date<=
    to_date('''||to_char(p_datetrack_date,'YYYY/MM/DD')||''',''YYYY/MM/DD'')';

Line: 965

    l_select_stmt:=l_select_stmt||'
    and to_date('''||to_char(p_datetrack_date,'YYYY/MM/DD')||''',''YYYY/MM/DD'')
    between effective_start_date and effective_end_date';

Line: 970

  l_select_stmt:=l_select_stmt||' order by effective_start_date';

Line: 975

  OPEN date_cv FOR l_select_stmt;