APPS.AP_WEB_EXPENSE_FORM SQL Statements

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

Line: 5

  SELECT
       alc.displayed_field
  FROM
       ap_pol_violations apv,
       ap_lookup_codes alc
  WHERE
       apv.violation_type = alc.lookup_code
   AND alc.lookup_type = 'OIE_POL_VIOLATION_TYPES'
   AND apv.report_header_id = p_report_header_id
   AND apv.distribution_line_number = p_line_number
  ORDER BY violation_number;

Line: 43

     select min(allowable_amount)
     into p_min_allowed_amount
     from ap_pol_violations_all
     where report_header_id = p_report_header_id
     and   distribution_line_number = p_distribution_line_number;

Line: 72

     select erp.category_code
     into l_category_code
     from ap_expense_report_params erp,
          ap_expense_report_lines erl
     where erl.report_header_id = p_report_header_id
       and erl.distribution_line_number = p_distribution_line_number
       and erl.web_parameter_id = erp.parameter_id;

Line: 115

  select count(*)
  into l_count
  from ap_expense_report_lines_all aerp
  where report_header_id = p_report_header_id
  and (itemization_parent_id is null or itemization_parent_id <> -1)
  and exists (select 1  from ap_pol_violations_all apv
              where apv.report_header_id = p_report_header_id
              and apv.distribution_line_number = aerp.distribution_line_number);

Line: 149

  select count(*)
  into l_count
  from ap_pol_violations_all apv
  where apv.report_header_id = p_report_header_id
  and   apv.distribution_line_number<> -1;

Line: 174

    select 'Y'
    into l_employee_is_active
    from per_workforce_current_x	-- Bug 3176205: view name changed from hr_employees_current_v to
    where person_id = p_employee_id;	-- per_workforce_current_x to consider Contingent workers as well.