APPS.PQP_CPYTAXRUL SQL Statements

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

Line: 26

select classification_id
from   pay_element_classifications pec
where  pec.classification_name = p_classification_name
  and  pec.legislation_code    = 'US'
  and  p_classification_name in
       ('Supplemental Earnings','Imputed Earnings','Pre-Tax Deductions');

Line: 36

select taxability_rules_date_id
from   pay_taxability_rules_dates trd
where  sysdate between trd.valid_date_from
       and trd.valid_date_to
  and  trd.legislation_code = 'US' ;

Line: 45

select jurisdiction_code,
       tax_type,
       status
from   pay_taxability_rules ptr
where  ptr.classification_id = l_classification_id
  and  ptr.legislation_code  = 'US'
  and  ptr.tax_category      = p_source_category
  and  (ptr.jurisdiction_code like p_source_state_code||'%' or
        p_source_state_code is null) ;

Line: 94

    Delete pay_taxability_rules
    where  classification_id = l_classification_id
      and  legislation_code  = 'US'
      and  tax_category      = p_target_category
      and  jurisdiction_code like p_target_state_code||'%' ;

Line: 113

      insert into pay_taxability_rules (jurisdiction_code,
					tax_type,
					tax_category,
					classification_id,
					taxability_rules_date_id,
					legislation_code,
					last_update_date,
					last_updated_by,
					last_update_login,
					created_by,
					creation_date,
                                        status )
                              values  ( l_jsd_code,
                                        tax_rul.tax_type,
                                        p_target_category,
                                        l_classification_id,
                                        l_tax_rules_date_id,
                                        'US',
                                        sysdate,
                                        -1,
                                        -1,
                                        -1,
                                        sysdate,
                                        tax_rul.status );