APPS.PAY_SE_HCIR SQL Statements

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

Line: 13

         SELECT action_information4 legal_employer_name, action_information5 org_number,
	        fnd_date.canonical_to_date(action_information6) curr_start_date,
		fnd_date.canonical_to_date (action_information7)curr_end_date,
		fnd_date.canonical_to_date (action_information8) prev_start_date,
		fnd_date.canonical_to_date (action_information9) prev_end_date,
                fnd_number.canonical_to_number (action_information10)
                      curr_avg_men_count,
                fnd_number.canonical_to_number (action_information11) curr_avg_women_count,
                fnd_number.canonical_to_number (action_information12)
                      prev_avg_men_count,
                fnd_number.canonical_to_number (action_information13) prev_avg_women_count, 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 = 'PYSEHCIA'
         AND   action_information2 = 'LE';

Line: 36

            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;