APPS.PAY_FI_UMFR SQL Statements

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

Line: 13

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

      select ACTION_INFORMATION2 TRADE_UNION_NAME, ACTION_INFORMATION4 LEGAL_EMPLOYER_NAME
from pay_action_information pai where
    pai.action_information_category = 'EMEA REPORT DETAILS'
   AND pai.action_context_type = 'PA'
   AND PAI.ACTION_CONTEXT_ID=csr_v_pa_id;

Line: 58

      select ACTION_INFORMATION2 TRADE_UNION_NAME, ACTION_INFORMATION4 LEGAL_EMPLOYER_NAME
from pay_action_information pai where
    pai.action_information_category = 'EMEA REPORT DETAILS'
   AND pai.action_context_type = 'PA'
   AND PAI.ACTION_CONTEXT_ID=csr_v_pa_id;

Line: 67

      select ACTION_INFORMATION2 TRADE_UNION_NAME, ACTION_INFORMATION4 LEGAL_EMPLOYER_NAME
from pay_action_information pai where
    pai.action_information_category = 'EMEA REPORT DETAILS'
   AND pai.action_context_type = 'PA'
   AND PAI.ACTION_CONTEXT_ID=csr_v_pa_id;

Line: 76

      SELECT pai.ACTION_INFORMATION2 TRADE_UNION_NAME, pai.ACTION_INFORMATION4 LEGAL_EMPLOYER_NAME,
null record_code ,
pai_le.action_information5 y_number,
       pai_lu.action_information5
             y_number_spare,
       pai_tu.action_information6 accounting_id, NULL accounting_id_spare,
       pai_tu.action_information5
             trade_union_number,
			 pai_lu.action_information4 local_unit_name,
       pai_lu.action_information6 local_unit_number,
       pai_per.action_information4
             employee_pin,
       pai_per.action_information5 employee_name,
       fnd_date.canonical_to_date(pai_per.action_information6)
             membership_start_date,
       fnd_date.canonical_to_date(pai_per.action_information7)
             membership_end_date, '1' currency,
       pai_per.action_information9
             SIGN, pai_per.action_information8 amount,
       '00' reason, to_char(fnd_date.canonical_to_date(pai.action_information9),'RRRR') tax_year, NULL sequence_number
  FROM pay_assignment_actions asgact, --                pay_payroll_actions payact,
      pay_action_information pai,
       pay_action_information pai_per,
       pay_action_information pai_lu,
       pay_action_information pai_le,
       pay_action_information pai_tu
 WHERE asgact.payroll_action_id = csr_v_pa_id
   AND pai_per.action_context_type = 'AAP'
   AND pai_per.action_information1 = 'PYFIUMFR'
   AND pai_per.action_information_category = 'EMEA REPORT INFORMATION'
   AND asgact.assignment_action_id = pai_per.action_context_id
   AND pai_lu.action_information3 = pai_per.action_information3
   AND pai_lu.action_information2 = 'LU'
   AND pai_lu.action_information1 = 'PYFIUMFR'
   AND pai_lu.action_information_category = 'EMEA REPORT INFORMATION'
   AND pai_lu.action_context_type = 'PA'
   AND pai_lu.action_context_id = csr_v_pa_id
   AND pai_le.action_information2 = 'LE'
   AND pai_le.action_information1 = 'PYFIUMFR'
   AND pai_le.action_information_category = 'EMEA REPORT INFORMATION'
   AND pai_le.action_context_type = 'PA'
   AND pai_le.action_context_id = csr_v_pa_id
   AND pai_tu.action_information2 = 'TU'
   AND pai_tu.action_information1 = 'PYFIUMFR'
   AND pai_tu.action_information_category = 'EMEA REPORT INFORMATION'
   AND pai_tu.action_context_type = 'PA'
   AND pai_tu.action_context_id = csr_v_pa_id
   and pai.action_information_category = 'EMEA REPORT DETAILS'
   AND pai.action_context_type = 'PA'
   AND PAI.ACTION_CONTEXT_ID=csr_v_pa_id
   order by pai.ACTION_INFORMATION2,pai.ACTION_INFORMATION4 ,pai_lu.action_information4  ;