APPS.HRI_OLTP_DISC_SALARY SQL Statements

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

Line: 18

  SELECT
    asg.assignment_number assignment_number
  , pro.proposed_salary_n salary_amount
  , ppb.pay_annualization_factor annualization_factor
  , ppb.pay_annualization_factor * pro.proposed_salary_n annual_salary
  FROM per_assignments_f asg /* Secure */
  , per_pay_bases ppb
  , per_pay_proposals pro
  , per_pay_proposals pro_next
  , pay_input_values_f piv
  , pay_element_types_f pet
  , pay_payrolls_f pay /* Secure */
  WHERE
/* Joins inc. date joins */
      pro.assignment_id = asg.assignment_id
  AND pro.change_date BETWEEN asg.effective_start_date
                      AND asg.effective_end_date
/* only show people who have a salary */
  AND asg.pay_basis_id = ppb.pay_basis_id
/* Next Pay proposal to get date */
  AND pro.assignment_id = pro_next.assignment_id
  AND pro.change_date = pro_next.last_change_date
/* Element entry types and currencies */
  AND ppb.input_value_id = piv.input_value_id
  AND piv.element_type_id = pet.element_type_id
  AND pro.change_date BETWEEN pet.effective_start_date
                      AND pet.effective_end_date
/* Payrolls and periods */
  AND asg.payroll_id = pay.payroll_id
  AND pro.change_date BETWEEN pay.effective_start_date
                      AND pay.effective_end_date
  AND pro_next.pay_proposal_id = cp_pay_proposal_id;

Line: 85

  select annual_salary
  from HRIFV_SAL_PRO
  where assignment_id = cp_assignment_id
  and   cp_effective_date between effective_from_date and effective_to_date_nn;