DBA Data[Home] [Help]

APPS.PAY_PAYROLL_XML_EXTRACT_PKG SQL Statements

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

Line: 111

                                           updated other procedures as necessary for Payroll
                                           Simulation.
    07-Mar-2013 emunisek   115.16 16281614 Moved the procedure SIMULATION_GENERATE
                                           to package PAY_US_PAYSLIP_SIMULATION_MAIN
                                           so that this package can have no dependancies
                                           on Simulation Code.
    07-Mar-2013 pkoduri    115.17 16451278 Replaced orgId with BG Id for determinig the
                                           display of RATE DETAILS section on PDF Payslip.
  *****************************************************************************/

g_proc_name         varchar2(50);
Line: 225

        SELECT TRANSLATE (UPPER(end_user_column_name), ' /','__') tag_name,
               end_user_column_name segment_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: 234

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

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

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

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

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

	SELECT business_group_id
	FROM pay_payroll_actions ppa,
	pay_assignment_actions paa
	WHERE
	paa.payroll_action_id = ppa.payroll_action_id
	AND paa.assignment_action_id=cp_assgn_action_id;
Line: 626

    g_xml_table.delete();
Line: 634

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

								' SELECT NVL((select lei_information13 from hr_location_extra_info hle ,HR_LOCATIONS_ALL HLA '||
										'WHERE hle.information_type = ''HR_SELF_SERVICE_LOC_PREFERENCE''');
Line: 727

								' SELECT NVL((select org_information13 FROM hr_organization_information '||
										'WHERE org_information_context = ''HR_SELF_SERVICE_ORG_PREFERENCE'' and ORG_INFORMATION1=''PAYSLIP''');
Line: 734

								' SELECT NVL((select org_information13 FROM hr_organization_information '||
										'WHERE org_information_context = ''HR_SELF_SERVICE_BG_PREFERENCE'' and ORG_INFORMATION1=''PAYSLIP''');
Line: 757

								'SELECT NVL(hruserdt.get_table_value('||lt_per_bgId_value||',''ONLINE_PAYSLIP_DATE_CONTROL_TBL'',lt_state_cd'||
								',lt_element_type,lt_pay_date),''N'') INTO lt_ret_val FROM DUAL ;');
Line: 904

                  'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');
Line: 948

                  'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');
Line: 1016

              'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');
Line: 1058

              'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');
Line: 1125

    g_xml_table.delete();
Line: 1255

            pay_payroll_xml_extract_pkg.g_custom_params.delete(
                            pay_payroll_xml_extract_pkg.g_custom_params.last());
Line: 1268

        pay_payroll_xml_extract_pkg.g_custom_params.delete(
                        pay_payroll_xml_extract_pkg.g_custom_params.last());
Line: 1292

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

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

    g_xml_table.delete();
Line: 1369

    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)),
           DECODE (p_pre_payment_id,
                   NULL, 'NULL',
                   to_char(p_pre_payment_id))
      INTO l_action_information_id,
           l_action_context_id,
		   l_pre_payment_id
      FROM DUAL;
Line: 1472

                  'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');
Line: 1516

                  'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');
Line: 1566

              'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');
Line: 1608

              'pay_payroll_xml_extract_pkg.g_custom_xml.delete();');
Line: 1680

    g_xml_table.delete();