APPS.HR_AU_ROUTES SQL Statements

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

Line: 82

  select  to_date(hoi.org_information11,'yyyy/mm/dd hh24:mi:ss')
  from    hr_organization_information         hoi
  where   lower(hoi.org_information_context)  = 'business group information'
          and hoi.organization_id             = p_business_group_id;

Line: 124

  select  to_date(segment2,'YYYY/MM/DD HH24:MI:SS')
  from    hr_soft_coding_keyflex    hsck
  ,       per_all_assignments_f     paaf
  ,       pay_assignment_actions_v  paav
  where   p_effective_date  between paaf.effective_start_date and paaf.effective_end_date
          and paav.assignment_action_id   = p_assignment_action_id
          and paav.assignment_id          = paaf.assignment_id
          and paaf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id;