APPS.PER_PERFRMMO_XMLP_PKG SQL Statements

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

Line: 105

          select a.assignment_id,
            jbt.name,
            j.job_id,
            j.job_information1
      into ln_start_asg_id,
           lc_start_job,
           lid,
           lc_start_job_pcs
      from per_all_assignments_f   a,
           per_jobs                j,
           per_jobs_tl             jbt,
           hr_soft_coding_keyflex  s
      where a.person_id              = PERSON_ID1
        and a.primary_flag           = 'Y'
        and a.effective_start_date   = START_DATE
        and a.assignment_type        = 'E'
        and a.job_id                 = jbt.job_id(+)
        and jbt.language(+)          = userenv('LANG')
        and a.job_id                 = j.job_id(+)
        and a.soft_coding_keyflex_id = s.soft_coding_keyflex_id(+);

Line: 143

      select a.assignment_id,
             a.effective_start_date,
             jbt.name,
             j.job_id,
             j.job_information1
      into ln_end_asg_id,
           ld_effective_start_date,
           lc_end_job,
           lid,
           lc_end_job_pcs
      from per_all_assignments_f   a,
           per_jobs                j,
           per_jobs_tl             jbt,
           hr_soft_coding_keyflex  s
      where a.person_id              = PERSON_ID1
        and a.primary_flag           = 'Y'
        and a.effective_end_date     = END_DATE
        and a.assignment_type        = 'E'
        and a.job_id                 = jbt.job_id(+)
        and jbt.language(+)          = userenv('LANG')
        and a.job_id                 = j.job_id(+)
        and a.soft_coding_keyflex_id = s.soft_coding_keyflex_id(+);