APPS.PAY_IN_BONUS_PKG SQL Statements

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

Line: 74

SELECT pdb.defined_balance_id
  FROM pay_defined_balances   pdb
      ,pay_balance_types      pbt
      ,pay_balance_dimensions pbd
 WHERE pdb.legislation_code = 'IN'
   AND pbt.legislation_code = 'IN'
   AND pbd.legislation_code = 'IN'
   AND pdb.balance_type_id = pbt.balance_type_id
   AND pbt.balance_name = 'F16 Gross Salary less Allowances'
   AND pdb.balance_dimension_id = pbd.balance_dimension_id
   AND pbd.database_item_suffix = '_ASG_RUN';

Line: 87

select paa1.assignment_action_id
      ,ppa1.date_earned
  from pay_assignment_actions paa1
      ,pay_payroll_actions    ppa1
 where ppa1.payroll_action_id = paa1.payroll_action_id
    and assignment_action_id = (SELECT max(paa.assignment_action_id)
  FROM pay_assignment_actions paa
      ,pay_payroll_actions    ppa
 WHERE paa.assignment_id = p_assignment_id
   AND ppa.payroll_action_id = paa.payroll_action_id
   AND ppa.date_earned BETWEEN p_fy_start_date
                           AND p_date_earned
   AND ppa.action_type IN ('Q','R','B','V','I')
   AND ppa.action_status  = 'C'
   AND paa.action_status  = 'C') ;