APPS.PAY_PAYUSTOT_XMLP_PKG SQL Statements

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

Line: 41

      SELECT UPPER(parameter_value)
      INTO trace
      FROM pay_action_parameters
      WHERE parameter_name = 'TRACE';

Line: 71

  SELECT d_tax_type,
    d_tax_classification,
    d_wage_classification,
    d_wage_otd_value,
    d_tax_otd_value
  FROM pay_us_federal_tax_bal_gre_v
  WHERE d_balance_set_name LIKE 'GRE_TOTALS_FED_YTD'
   AND d_tax_unit_id = gre_id;

Line: 184

      SELECT DISTINCT d_tax_classification,
        d_wage_classification,
        d_tax_otd_value,
        d_wage_otd_value
      FROM pay_us_state_tax_bal_gre_v
      WHERE d_balance_set_name = 'GRE_TOTALS_STATE_YTD'
       AND d_tax_unit_id = gre_id
       AND SUBSTR(d_state_code,   1,   2) = state_code
       AND d_tax_type = 'SIT';

Line: 251

      SELECT paf.person_id,
        paf.assignment_id,
        paaf.assignment_action_id
      FROM per_assignments_f paf,
        pay_assignment_actions paaf,
        pay_payroll_actions ppa,
        hr_soft_coding_keyflex hsck
      WHERE(ppa.effective_date BETWEEN p_start_date
       AND p_end_date)
       AND ppa.payroll_action_id = paaf.payroll_action_id
       AND paaf.assignment_id = paf.assignment_id
       AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
       AND hsck.segment1 = p_gre_org_id
       AND paf.business_group_id = p_business_group_id;

Line: 286

          SELECT sein.org_information3
          INTO l_sui_ein
          FROM hr_organization_information sein
          WHERE sein.organization_id = gre_id
           AND sein.org_information1 = state
           AND sein.org_information_context = 'State Tax Rules';