APPS.PAY_US_TAX_ETU_PKG SQL Statements

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

Line: 30

  SELECT prt.* from pay_run_types_f  prt
   WHERE prt.run_type_name IN ('Regular Standard Run',
                               'Separate Payment Run',
                               'Tax Separate Run',
                               'Supplemental Standard Run',
                               'Regular',
                               'Supplemental')
    AND  prt.business_group_id IS NULL
    AND  prt.legislation_code = 'US';

Line: 46

  SELECT  element_type_id
    FROM  pay_element_types_f
   WHERE  element_name = p_element_name
     AND  legislation_code  = 'US'
     AND  business_group_id IS NULL;

Line: 77

        pay_us_vertex_interface.delete_ele_type_usages('VERTEX'
                                                      , p_business_group_id);

Line: 83

        pay_us_vertex_interface.delete_ele_type_usages('US_TAX_VERTEX'
                                                      , p_business_group_id);

Line: 88

        pay_us_vertex_interface.delete_ele_type_usages('Workers Compensation'
                                                      , p_business_group_id);