APPS.PAY_NL_NWR_XML_EXTRACT_PKG SQL Statements

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

Line: 19

        SELECT tag
          FROM fnd_lookup_values
         WHERE lookup_type = 'FND_ISO_CHARACTER_SET_MAP'
           AND lookup_code = SUBSTR(USERENV('LANGUAGE'),
                                    INSTR(USERENV('LANGUAGE'), '.') + 1)
           AND language = 'US';

Line: 42

    SELECT value
    INTO db_charset
    FROM nls_database_parameters
    WHERE parameter = 'NLS_CHARACTERSET';

Line: 100

SELECT  meaning
       ,nvl(start_date_active,fnd_date.canonical_to_date('0001/01/01 00:00:00'))  active_date
FROM   hr_lookups
WHERE lookup_type = 'NL_FORM_LABELS'
  --AND lookup_code like l_tag||'%'
  AND (lookup_code like l_tag||'%'||g_year OR lookup_code = l_tag)
  AND nvl(to_char(start_date_active,'RRRR'),'0001') <= g_year
  AND nvl(to_char(end_date_active,'RRRR'),'4712') >= g_year
  AND enabled_flag = 'Y'
--ORDER BY 2 desc;

Line: 139

    SELECT TRANSLATE ((description), ' /','__') tag_name
    FROM  fnd_descr_flex_col_usage_tl
    WHERE application_id                = 801
    AND   source_lang = 'US'
    AND   descriptive_flexfield_name    = 'Action Information DF'
    AND   descriptive_flex_context_code = p_context_code
    AND   application_column_name       = UPPER(p_node);

Line: 148

    SELECT 'N'
    FROM hr_lookups
    WHERE lookup_type = 'PAY_NL_INVALID_WR_TAGS'
    AND lookup_code   = upper(l_tag)
    AND description   =  l_tag
    AND enabled_flag  = 'Y'
    AND (to_char(start_date_active,'RRRR') <= g_year
         AND nvl(to_char(end_date_active,'RRRR'),'4712') >= g_year);

Line: 225

    SELECT TRANSLATE ((description), ' /','__') tag_name
    FROM  fnd_descr_flex_col_usage_tl
    WHERE application_id                = 801
    AND   source_lang = 'US'
    AND   descriptive_flexfield_name    = 'Action Information DF'
    AND   descriptive_flex_context_code = p_context_code
    AND   application_column_name       = UPPER (p_node);

Line: 234

    SELECT 'N'
    FROM hr_lookups
    WHERE lookup_type = 'PAY_NL_INVALID_WR_TAGS'
    AND lookup_code   = upper(l_tag)
    AND description   =  l_tag
    AND enabled_flag  = 'Y'
    AND (to_char(start_date_active,'RRRR') <= g_year
         AND nvl(to_char(end_date_active,'RRRR'),'4712') >= g_year);

Line: 305

    SELECT 'Y'
    FROM fnd_descr_flex_col_usage_vl
    WHERE application_id                 = 801
    AND descriptive_flexfield_name  LIKE 'Action Information DF'
    AND descriptive_flex_context_code    =  p_context_code
    AND application_column_name       LIKE  p_application_column_name
    AND enabled_flag                     =  'Y';

Line: 355

    SELECT hoi1.org_information14
    FROM hr_organization_units hou
        ,hr_organization_information hoi
        ,hr_organization_information hoi1
    WHERE hou.organization_id = hoi.organization_id
    AND	  hou.organization_id = hoi1.organization_id(+)
    AND	  hou.organization_id = p_organization_id
    AND	  hoi.org_information_context = 'CLASS'
    AND	  hoi1.org_information_context(+) = 'NL_ORG_INFORMATION';

Line: 902

    SELECT include_or_exclude
    FROM   hr_assignment_set_amendments hasa
    WHERE  hasa.assignment_set_id = p_assignment_set_id;

Line: 907

    SELECT TO_CHAR(effective_date,'RRRR')
    FROM   pay_payroll_actions
    WHERE  payroll_action_id = c_payroll_action_id;

Line: 1497

    g_xml_nwr.delete();