APPS.PAY_FI_PAYLIST SQL Statements

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

Line: 12

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

      SELECT pai.action_information4 payroll_name,
       pai.action_information5
             payment_month,
              pai.action_information6 pay_day,
       pai.action_information7
             end_date
         FROM pay_action_information pai,
      pay_payroll_actions ppa
 WHERE pai.action_context_id = ppa.payroll_action_id
   AND ppa.payroll_action_id = csr_v_pa_id;

Line: 67

      SELECT
       pai_ass.action_information3 person_name,
       pai_ass.action_information4
             salary,
       pai_ass.action_information5 benefits,
       pai_ass.action_information6
             insurance_salary,
       pai_ass.action_information7
             deductions_withhold_tax,
       pai_ass.action_information8 tax_income,
       pai_ass.action_information9
             withhold_tax,
       pai_ass.action_information10 expenses,
       pai_ass.action_information11
             after_tax_deductions,
       pai_ass.action_information12 net_pay,
      pai_ass.action_information13 capital_income_base,
      pai_ass.action_information14 assignment_number
  FROM pay_payroll_actions ppa,
       pay_assignment_actions paa,
       pay_action_information pai_ass
 WHERE ppa.payroll_action_id = csr_v_pa_id
   AND paa.payroll_action_id = ppa.payroll_action_id
   AND paa.assignment_action_id = pai_ass.action_context_id
   AND pai_ass.action_context_type = 'AAP'
   AND pai_ass.action_information1 = 'PYFIPAYL'
   AND pai_ass.action_information_category = 'EMEA REPORT INFORMATION';

Line: 97

      SELECT
       SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information4))
             salary,
       SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information5)) benefits,
       SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information6))
             insurance_salary,
       SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information7))
             deductions_withhold_tax,
       SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information8)) tax_income,
       SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information9))
             withhold_tax,
       SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information10) )expenses,
       SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information11))
             after_tax_deductions,
       SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information12))net_pay,
      SUM(FND_NUMBER.CANONICAL_TO_NUMBER(pai_ass.action_information13)) capital_income_base
  FROM pay_payroll_actions ppa,
       pay_assignment_actions paa,
       pay_action_information pai_ass
 WHERE ppa.payroll_action_id = csr_v_pa_id
   AND paa.payroll_action_id = ppa.payroll_action_id
   AND paa.assignment_action_id = pai_ass.action_context_id
   AND pai_ass.action_context_type = 'AAP'
   AND pai_ass.action_information1 = 'PYFIPAYL'
   AND pai_ass.action_information_category = 'EMEA REPORT INFORMATION';