APPS.HR_FR_ASG_RULES SQL Statements

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

Line: 66

  select count(*)
  from   per_all_assignments_f asg
  where  asg.period_of_service_id = p_period_of_service_id
  and    asg.assignment_type = 'E'
  and    asg.assignment_id <> p_assignment_id
  and    asg.effective_start_date <> p_effective_start_date
  and    asg.effective_end_date <> p_effective_end_date;