APPS.PER_SG_PERWSEPI SQL Statements

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

Line: 24

      select fct.form_left_prompt,
             fcu.required_flag
      from   fnd_descr_flex_col_usage_tl fct,
             fnd_descr_flex_column_usages fcu
      where  fcu.application_id                = fct.application_id
      and    fcu.descriptive_flexfield_name    = fct.descriptive_flexfield_name
      and    fcu.descriptive_flex_context_code = fct.descriptive_flex_context_code
      and    fcu.application_column_name       = fct.application_column_name
      and    fct.language                      = userenv('LANG')
      and    fcu.descriptive_flexfield_name    = c_flexfield_name
      and    fcu.descriptive_flex_context_code = c_flexfield_context
      and    fcu.application_column_name       = c_flexfield_segment;

Line: 74

    select territory_short_name
    from   fnd_territories_vl
    where  territory_code = c_territory_code;

Line: 81

    select meaning
    from   hr_lookups
    where  lookup_type    = c_lookup_type
    and    lookup_code    = c_lookup_code
    and    application_id = g_application_id;