APPS.PAY_PAYUSTIM_XMLP_PKG SQL Statements

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

Line: 11

     CURSOR p_trace IS select upper(parameter_value)
    from pay_action_parameters
    where parameter_name = 'TRACE';

Line: 39

 select tax_unit_id,
        attribute2,
        to_number(attribute3),
        to_date(attribute4,'MM/DD/YYYY'),
       to_date(attribute5,'MM/DD/YYYY')
   into PACTID,
        l_param,
        p_business_group_id,
        p_start_date,
        p_end_date
   from pay_us_rpt_totals
  where organization_id = to_number(PPA_FINDER)
    and attribute1  = 'TIAA-CREF'
    and rownum=1;

Line: 64

delete from pay_us_rpt_totals where tax_unit_id = pactid;

Line: 80

select attribute19
into
   l_flag
   from pay_us_rpt_totals
  where tax_unit_id = pactid
    and attribute1  = 'TIAA-CREF'
and  rownum=1;

Line: 89

delete from pay_us_rpt_totals where tax_unit_id = pactid;

Line: 93

  update pay_us_rpt_totals
 set attribute19='Y'
 where tax_unit_id = pactid
 and attribute1  = 'TIAA-CREF';

Line: 112

     select distinct payroll_name,'Payroll    : '||payroll_name
       into cp_payroll_name,cp_print_set_payroll_name
       from pay_payrolls_f
      where payroll_id = p_payroll_id
        and effective_start_date <= p_start_date
        and effective_end_date >= p_end_date;

Line: 121

     select consolidation_set_name,'Consolidation Set : '||consolidation_set_name
       into cp_consolidation_set_name,cp_print_set_payroll_name
       from pay_consolidation_sets
      where consolidation_set_id = p_consolidation_set_id;

Line: 128

     select name
       into cp_gre_name
       from hr_organization_units
      where organization_id = p_gre_id;

Line: 139

delete from pay_us_rpt_totals where tax_unit_id = pactid;

Line: 148

select
   distinct attribute15  err_message
from pay_us_rpt_totals  purt
where  tax_unit_id =pactid
  and  attribute1<>'TIAA-CREF'
  and attribute14 is not null
  and attribute5  = assg_exp;