APPS.PAY_PAYROLL_XML_EXTRACT_PKG SQL Statements

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

Line: 195

        SELECT TRANSLATE (UPPER(end_user_column_name), ' /','__') tag_name
          FROM fnd_descr_flex_col_usage_vl
         WHERE descriptive_flexfield_name = p_flexfield_name
           AND descriptive_flex_context_code = p_context_code
           AND application_column_name = UPPER (p_node)
           AND application_id = 801; /* Bug 6522667 */

Line: 203

        SELECT paa_chk.serial_number
          FROM pay_assignment_actions paa_xfr,
               pay_action_interlocks pai_xfr,
               pay_action_interlocks pai_chk,
               pay_assignment_actions paa_chk,
               pay_payroll_actions ppa_chk
         WHERE paa_xfr.assignment_action_id = pai_xfr.locking_action_id
           AND pai_xfr.locked_action_id = pai_chk.locked_action_id
           AND pai_chk.locking_action_id = paa_chk.assignment_action_id
           AND paa_chk.payroll_action_id = ppa_chk.payroll_action_id
           AND ppa_chk.action_type = 'H'
           AND paa_xfr.assignment_action_id = g_action_ctx_id;

Line: 301

        SELECT TRANSLATE (UPPER(seg.segment_name), ' /','__')
          FROM fnd_id_flex_structures_vl ctx,
               fnd_id_flex_segments_vl seg
         WHERE ctx.id_flex_num = seg.id_flex_num
           AND ctx.id_flex_code = seg.id_flex_code
           AND seg.id_flex_code = 'BANK'
           AND ctx.id_flex_structure_code = p_id_flex_structure_code
           AND seg.application_column_name = UPPER(p_node);

Line: 401

        SELECT 'Y'
          FROM fnd_descr_flex_col_usage_vl
         WHERE 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 application_id = 801 /* Bug 6522667 */
           AND enabled_flag = 'Y';

Line: 476

        SELECT hoi2.org_information9
          FROM pay_assignment_actions paa,
               pay_payroll_actions ppa,
               hr_organization_units hou,
               hr_organization_information hoi1,
               hr_organization_information hoi2
         WHERE paa.payroll_action_id = ppa.payroll_action_id
           AND ppa.business_group_id = hou.organization_id
           AND hou.organization_id = hoi1.organization_id
           AND hoi1.organization_id = hoi2.organization_id
           AND ppa.effective_date BETWEEN hou.date_from
                                      AND nvl(hou.date_to,
                                              hr_general.end_of_time)
           AND hoi1.org_information_context = 'CLASS'
           AND hoi1.org_information1 = 'HR_BG'
           AND hoi2.org_information_context = 'Business Group Information'
           AND ppa.action_type = 'X'
           AND NVL (p_action_context_id, (SELECT action_context_id
                                            FROM pay_action_information
                                           WHERE action_information_id =
                                                      p_action_information_id))
                                                    = paa.assignment_action_id;

Line: 500

        SELECT DISTINCT action_information_category
          FROM pay_action_information
         WHERE ((action_context_type = 'AAP'
             AND action_context_id = p_action_context_id)
             OR (action_context_type = 'PA'
             AND action_context_id =
                    (SELECT payroll_action_id
                       FROM pay_assignment_actions
                      WHERE assignment_action_id = p_action_context_id)))
            OR (action_information_id = p_action_information_id
            AND p_action_information_id IS NOT NULL)
      ORDER BY decode (action_information_category,'EMPLOYEE DETAILS', 1, 2);

Line: 554

    g_xml_table.delete();

Line: 562

    SELECT DECODE (p_action_information_id,
                   NULL, 'NULL',
                   to_char(p_action_information_id)),
           DECODE (p_action_context_id,
                   NULL, 'NULL',
                   to_char(p_action_context_id))
      INTO l_action_information_id,
           l_action_context_id
      FROM DUAL;

Line: 701

                  'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');

Line: 745

                  'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');

Line: 799

              'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');

Line: 841

              'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');

Line: 908

    g_xml_table.delete();

Line: 1038

            pay_payroll_xml_extract_pkg.g_custom_params.delete(
                            pay_payroll_xml_extract_pkg.g_custom_params.last());

Line: 1051

        pay_payroll_xml_extract_pkg.g_custom_params.delete(
                        pay_payroll_xml_extract_pkg.g_custom_params.last());