APPS.BEN_EXT_PAYROLL_BALANCE SQL Statements

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

Line: 14

  select to_number(sft.segment1)
    from hr_soft_coding_keyflex sft,
         per_assignments_f      asg
   where sft.soft_coding_keyflex_id = asg.soft_coding_keyflex_id
     and asg.assignment_id          = c_assignment_id
     and c_effective_date between asg.effective_start_date
                              and asg.effective_end_date;

Line: 25

  select str.jurisdiction_code
    from pay_us_emp_state_tax_rules_f str
   where c_effective_date between str.effective_start_date
                              and str.effective_end_date
     and    str.assignment_id     = c_assignment_id
     and str.business_group_id = c_business_group_id;

Line: 35

  select asg.ESTABLISHMENT_ID
    from per_all_assignments_f asg
   where asg.assignment_id = c_assignment_id
     and c_effective_date between asg.effective_start_date
                              and asg.effective_end_date
  ;

Line: 44

  select pbd.DIMENSION_NAME
  from ff_contexts ffc
      ,ff_route_context_usages frc
      ,pay_defined_balances pdb
      ,pay_balance_dimensions pbd
 where pdb.defined_balance_id = p_defined_balance_id
   and pdb.balance_dimension_id = pbd.balance_dimension_id
   and pbd.route_id = frc.route_id
   and frc.context_id = ffc.context_id
   and ffc.context_name = 'TAX_UNIT_ID'
  ;