APPS.PAY_AC_UTILITY SQL Statements

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

Line: 32

      select org_information9
      from   hr_organization_information
      where  org_information_context = 'Business Group Information'
      and    organization_id = cp_bus_grp_id;

Line: 39

      select balance_dimension_id
      from   pay_balance_dimensions
      where  legislation_code = cp_legislation_cd
      and    dimension_name   = cp_dimension_name;

Line: 46

      select balance_dimension_id
      from   pay_balance_dimensions
      where  legislation_code       = cp_legislation_cd
      and    database_item_suffix   = cp_database_item_suffix;

Line: 53

      select defined_balance_id
      from   pay_defined_balances
      where  balance_type_id       = cp_bal_typ_id
      and    balance_dimension_id  = cp_bal_dim_id;

Line: 133

      select balance_type_id
      from   pay_balance_types
      where  balance_name     = p_balance_name
      and    (( business_group_id = cp_bus_grp_id and
                cp_legislation_cd is null ) or
              ( legislation_code = cp_legislation_cd and
                cp_bus_grp_id is null ) );

Line: 173

      select balance_name, reporting_name
      from   pay_balance_types_tl pbt
      where  balance_type_id      = cp_balance_type_id
      and    language             = USERENV('LANG') ;

Line: 379

       select parameter_value
       from pay_action_parameters
       where parameter_name = 'RANGE_PERSON_ID';

Line: 384

       select par.parameter_value
         from pay_report_format_parameters par,
              pay_report_format_mappings_f map
        where map.report_format_mapping_id = par.report_format_mapping_id
          and map.report_type = p_report_type
          and map.report_format = p_report_format
          and map.report_qualifier = p_report_qualifier
          and map.report_category = p_report_category
          and par.parameter_name = 'RANGE_PERSON_ID';

Line: 440

       select state_code || '-000-0000'
         from pay_us_states
        where state_abbrev = cp_state_abbrev;

Line: 446

       select puc.state_code || '-' || puc.county_code || '-0000'
         from pay_us_states pus,
              pay_us_counties puc
        where pus.state_abbrev = cp_state_abbrev
          and puc.state_code = pus.state_code
          and puc.county_name = cp_county_name;