APPS.HR_NZ_ROUTES SQL Statements

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

Line: 76

  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: 118

    SELECT to_date(segment2,'YYYY/MM/DD HH24:MI:SS')
      FROM hr_soft_coding_keyflex    hsck
         , per_assignments_f         paaf
         , pay_assignment_actions    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;