APPS.PAY_AC_UTIL SQL Statements

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

Line: 95

       select state_abbrev
         from pay_us_states
        where state_code  = cp_state_code;

Line: 102

       select county_name
         from pay_us_counties
        where state_code  = cp_state_code
          and county_code = cp_county_code;

Line: 111

       select city_name
         from pay_us_city_names
        where state_code    = cp_state_code
          and county_code   = cp_county_code
          and city_code     = cp_city_code
          and primary_flag  = 'Y';

Line: 163

       select state_abbrev
         from pay_us_states
        where state_code  = cp_state_code;

Line: 192

  select hoi.org_information10
  from hr_organization_units hou,
       hr_organization_information hoi
  where hou.business_group_id = p_business_group_id
    and hou.organization_id = hoi.organization_id
    and hoi.org_information_context = 'Business Group Information';

Line: 226

  select consolidation_set_name
  from pay_consolidation_sets
  where consolidation_set_id = cp_consolidation_set_id
    and business_group_id = p_business_group_id;

Line: 252

  select payroll_name
  from pay_all_payrolls_f
  where payroll_id = cp_payroll_id
    and business_group_id = p_business_group_id
    and p_effective_date between effective_start_date
                             and effective_end_date;

Line: 319

  select bal.balance_name
       , def.legislation_code
       , def.defined_balance_id
       , bal.balance_type_id
       , dim.balance_dimension_id
  from  pay_balance_types bal,
        pay_balance_dimensions dim,
        pay_defined_balances def
  where bal.legislation_code = cp_legislation_code
  and bal.balance_name in ( cp_balance_name )
  and dim.legislation_code = cp_legislation_code
  and dim.dimension_name = 'Assignment within Government Reporting Entity Run'
  and def.legislation_code = cp_legislation_code
  and def.balance_type_id = bal.balance_type_id
  and def.balance_dimension_id = dim.balance_dimension_id;