APPS.HR_LOOKUPS_UTIL_PKG SQL Statements

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

Line: 63

  select field_name into l_localized_lookup_code
  from pay_legislative_field_info
  where rule_type = 'LOCAL_LOOKUP'
  and legislation_code = p_legislation_code
  and validation_name = p_lookup_code
  and validation_type = p_lookup_type;

Line: 107

  select validation_name into l_global_lookup_code
  from pay_legislative_field_info
  where rule_type = 'LOCAL_LOOKUP'
  and legislation_code = p_legislation_code
  and field_name = p_lookup_code
  and validation_type = p_lookup_type;