APPS.PAY_NL_NWR_XML_EXTRACT_PKG SQL Statements

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

Line: 23

        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: 46

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

Line: 104

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: 149

    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: 158

    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 (g_year BETWEEN to_char(start_date_active,'RRRR')
         AND nvl(to_char(end_date_active,'RRRR'),'4712'));

Line: 168

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

Line: 259

    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: 268

    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 (g_year BETWEEN to_char(start_date_active,'RRRR')
         AND nvl(to_char(end_date_active,'RRRR'),'4712'));

Line: 278

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

Line: 359

    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: 409

    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: 1338

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

Line: 1343

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

Line: 1349

    SELECT  put.user_table_id
           ,puc.user_column_id
    FROM    pay_user_tables put
           ,pay_user_columns puc
    WHERE   put.user_table_id = puc.user_table_id
    AND     put.legislation_code = puc.legislation_code
    AND     put.user_table_name = 'NL_DIACRITICAL_MARKS'
    AND     put.legislation_code = 'NL';

Line: 1362

    SELECT  DISTINCT
            UPPER (purf.row_low_range_or_name) Source
           ,UPPER (pucif.value) Target
    FROM    pay_user_column_instances_f pucif
           ,pay_user_rows_f purf
    WHERE   pucif.user_column_id = p_user_column_id
    AND     purf.user_table_id = p_user_table_id
    AND     pucif.user_row_id = purf.user_row_id
    AND     pucif.business_group_id = purf.business_group_id
    AND     pucif.business_group_id = p_business_group_id
    AND     p_start_date BETWEEN pucif.EFFECTIVE_START_DATE AND pucif.EFFECTIVE_END_DATE
    AND     p_start_date BETWEEN purf.EFFECTIVE_START_DATE AND purf.EFFECTIVE_END_DATE;

Line: 1376

    SELECT  business_group_id
           ,start_date
    FROM    pay_payroll_actions
    WHERE   payroll_action_id = p_payroll_action_id;

Line: 2134

    g_xml_nwr.delete();