APPS.PAY_SE_TRNR SQL Statements

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

Line: 10

         SELECT fnd_date.canonical_to_date (action_information5) joinig_start_date,
                fnd_date.canonical_to_date (action_information6)
                      joinig_end_date, action_information9 division,
                action_information12 agreement_area, action_information13 empployee_category,
                action_information14
                      assignment_category,
                fnd_date.canonical_to_date (action_information16) start_date_of_birth,
                fnd_date.canonical_to_date (action_information17)
                      end_date_of_birth,
                fnd_date.canonical_to_date (action_information18) precedence_end_date,
                fnd_date.canonical_to_date (action_information19)
                      report_date, action_information20 sort_order
         FROM   pay_action_information
         WHERE action_context_id = p_payroll_action_id AND action_information_category = 'EMEA REPORT DETAILS';

Line: 31

         SELECT action_information3 legal_emp_id, action_information4 legal_employer_name, action_information5 org_number,
                effective_date
         FROM   pay_action_information
         WHERE action_context_type = 'PA'
         AND   action_context_id = csr_v_pa_id
         AND   action_information_category = 'EMEA REPORT INFORMATION'
         AND   action_information1 = 'PYSETRNA'
         AND   action_information2 = 'LE';

Line: 46

         SELECT DISTINCT action_information14 division_code, action_information16 division
         FROM            pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai
         WHERE  paa.payroll_action_id = p_payroll_action_id
         AND    assg.payroll_action_id = paa.payroll_action_id
         AND    pai.action_context_id = assg.assignment_action_id
         AND    action_context_type = 'AAP'
         --AND   action_context_id = csr_v_pa_id
         AND    action_information_category = 'EMEA REPORT INFORMATION'
         AND    action_information1 = 'PYSETRNA'
         AND    action_information13 = p_legal_employer_id;

Line: 63

         SELECT DISTINCT action_information15 area_code, action_information17 agreement_area
         FROM            pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai
         WHERE  paa.payroll_action_id = p_payroll_action_id
         AND    assg.payroll_action_id = paa.payroll_action_id
         AND    pai.action_context_id = assg.assignment_action_id
         AND    action_context_type = 'AAP'
         --AND   action_context_id = csr_v_pa_id
         AND    action_information_category = 'EMEA REPORT INFORMATION'
         AND    action_information1 = 'PYSETRNA'
         AND    action_information13 = p_legal_employer_id
         AND    action_information14 = p_div;

Line: 88

      l_select_str            VARCHAR2 (3000);

Line: 97

            SELECT payroll_action_id
            INTO  l_payroll_action_id
            FROM   pay_payroll_actions ppa, fnd_conc_req_summary_v fcrs, fnd_conc_req_summary_v fcrs1
            WHERE fcrs.request_id = fnd_global.conc_request_id
            AND   fcrs.priority_request_id = fcrs1.priority_request_id
            AND   ppa.request_id BETWEEN fcrs1.request_id AND fcrs.request_id
            AND   ppa.request_id = fcrs1.request_id;

Line: 116

      SELECT 'order by '
             || decode (
                   nvl (rec_report_parameters.sort_order, 'EMP_TIME'),
                   'EMP_TIME', ' total_emp_time desc ',
                   'ASG_NUM', ' assignment_number asc ',
                   'NAME', ' full_name asc ',
                   'PIN', ' national_identifier asc '
                )
      INTO  l_sort_order
      FROM   dual;

Line: 199

               l_select_str :=
                  'SELECT   action_information4 national_identifier,
                  action_information5
                        assignment_number, action_information6 full_name,
                  fnd_date.canonical_to_date (action_information7)
                        hire_date,
                  fnd_number.canonical_to_number (action_information8) total_emp_time,
                  fnd_date.canonical_to_date (action_information9)
                        precedence_date,
                  fnd_date.canonical_to_date (action_information10) termination_date, action_information11 emp_type,
                  action_information12
                        emp_sec
         FROM     pay_payroll_actions paa, pay_assignment_actions assg, pay_action_information pai
         WHERE paa.payroll_action_id = '
                  || l_payroll_action_id
                  || ' AND   assg.payroll_action_id = paa.payroll_action_id
         AND   pai.action_context_id = assg.assignment_action_id
         AND   action_context_type = '
                  || '''AAP''' || ' AND   action_information_category = ' || '''EMEA REPORT INFORMATION'''
                  || ' AND   action_information1 = ' || '''PYSETRNA''' || ' AND   action_information13 = '
                  || rec_leg_emp.legal_emp_id || ' AND   action_information14 = ' || '''' || rec_all_division.division_code || ''''
                  || ' AND   action_information15 = ' || '''' || rec_all_area.area_code || '''' || ' ' || l_sort_order;

Line: 222

		  fnd_file.put_line (fnd_file.LOG, 'l_select_str :-  '||length(l_select_str));

Line: 232

               OPEN csr_get_emp FOR l_select_str;

Line: 280

		  l_select_str := null;