APPS.PQP_EXCP_RPT SQL Statements

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

Line: 20

  SELECT
  fnd_number.canonical_to_number(purt.business_group_id) business_group_id,
  fnd_number.canonical_to_number(purt.tax_unit_id)    payroll_action_id,
  fnd_number.canonical_to_number(purt.value1)         current_balance,
  fnd_number.canonical_to_number(purt.value2)         previous_balance,
  fnd_number.canonical_to_number(purt.attribute1)     balance_type_id,
  fnd_number.canonical_to_number(purt.attribute2)     report_id,
  fnd_number.canonical_to_number(purt.attribute3)     group_id,
  fnd_number.canonical_to_number(purt.attribute4)     consolidation_set_id,
  fnd_number.canonical_to_number(purt.attribute5)     payroll_id,
  fnd_number.canonical_to_number(purt.attribute6)     assignment_id,
  purt.attribute14                                    full_name,
  purt.attribute7                                     last_name,
  purt.attribute8                                     first_name,
  purt.attribute10                                    middle_name,
  purt.attribute9                                     national_id,
  purt.attribute11                                    effective_date,
  purt.attribute13                                    assignment_number
  FROM      pay_us_rpt_totals purt
  WHERE    organization_id=p_ppa_finder
    AND    purt.attribute12 = p_ppa_finder
  ORDER BY purt.attribute7;

Line: 54

  SELECT payroll_name
    FROM  pay_payrolls_f
   WHERE  payroll_id=p_payroll_id
     AND  consolidation_set_id=p_consolidation_set_id
     AND  (business_group_id = p_business_group_id
      OR    business_group_id IS NULL)
     AND  trunc(p_date) between effective_start_date and effective_end_date;

Line: 71

  SELECT consolidation_set_name
    from pay_consolidation_sets
   WHERE consolidation_set_id=p_consolidation_set_id
     AND (business_group_id =p_business_group_id
      OR business_group_id IS NULL);

Line: 85

  SELECT DISTINCT balance_name
       FROM  pay_balance_types
      WHERE  balance_type_id=p_balance_type_id;

Line: 96

  SELECT Distinct legislation_code,currency_code
    FROM per_business_groups
   WHERE business_group_id      =p_business_group_id;

Line: 112

  SELECT   variance_value
          ,comparison_value
	  ,exception_report_name
	  ,output_format
	  ,balance_dimension_id
     FROM   pqp_exception_reports
     WHERE  exception_report_id=p_report_id
       AND  (business_group_id IS NULL
        OR   business_group_id=p_business_group_id)
       AND  (legislation_code IS NULL
        OR    legislation_code=p_legislation_code) ;

Line: 135

  SELECT meaning
    FROM  hr_lookups
   WHERE  lookup_type='PQP_COMPARISON_TYPE'
     AND   lookup_code=(
    SELECT   comparison_type
      FROM   pqp_exception_reports
     WHERE  exception_report_id=p_report_id
       AND  (business_group_id IS NULL
        OR   business_group_id=p_business_group_id)
       AND  (legislation_code IS NULL
        OR    legislation_code=p_legislation_code)) ;

Line: 157

  SELECT  distinct hrl.meaning
    FROM   pqp_exception_reports per,
           hr_lookups hrl
   WHERE  per.exception_report_id=p_report_id
     AND  (per.business_group_id IS NULL
      OR   per.business_group_id=p_business_group_id)
     AND  (per.legislation_code IS NULL
      OR    per.legislation_code=p_legislation_code)
     AND  hrl.lookup_type = 'PQP_VARIANCE_TYPES'
     AND  hrl.lookup_code = per.variance_type;

Line: 178

  SELECT  meaning
    FROM  HR_LOOKUPS HRL
   WHERE  HRL.LOOKUP_TYPE = 'PQP_OPERATOR_TYPES'
     AND  HRL.ENABLED_FLAG = 'Y'
     AND  LOOKUP_CODE =(
     SELECT  distinct variance_operator
       FROM   pqp_exception_reports
      WHERE  exception_report_id=p_report_id
        AND  (business_group_id IS NULL
         OR   business_group_id=p_business_group_id)
        AND  (legislation_code IS NULL
         OR    legislation_code=p_legislation_code));

Line: 199

  SELECT EXCEPTION_GROUP_NAME
    FROM pqp_exception_report_groups
   WHERE EXCEPTION_GROUP_ID = p_group_id;

Line: 211

  select pbd.dimension_name dimension_name
    from pay_balance_dimensions pbd,
         pay_defined_balances pdb,
         pqp_exception_report_suffix ers
   where pbd.database_item_suffix = ers.database_item_suffix
     and ers.legislation_code = userenv('LANG')
     and pbd.balance_dimension_id = pdb.balance_dimension_id
     and pdb.balance_dimension_id = p_dimension_id;

Line: 226

  SELECT output_format
    FROM pqp_exception_reports
   WHERE exception_report_name = p_report_name
     AND (business_group_id= p_business_group_id
          OR business_group_id IS NULL)
  UNION
  SELECT DISTINCT output_format
    FROM pqp_exception_report_groups
   WHERE exception_group_name = p_group_name
     AND (business_group_id= p_business_group_id
          OR business_group_id IS NULL);

Line: 566

    DELETE FROM pay_us_rpt_totals
     WHERE organization_id =p_ppa_finder
       AND attribute12 = p_ppa_finder;

Line: 570

    hr_utility.trace('Deleted the rows from the pay_us_rpt_totals');