APPS.PER_GET_ASG_POS SQL Statements

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

Line: 14

    select effective_start_date,
           effective_end_date
    from per_all_assignments_f x
    where p_assignment_id = x.assignment_id
    and p_position_id = x.position_id
    and   p_effective_start_date >= x.effective_start_date
    order by x.effective_start_date desc;

Line: 48

    select asg.effective_start_date,
 	   asg.effective_end_date
    from	 per_all_assignments_f asg
		,per_assignment_status_types past
    where p_assignment_id = assignment_id
    and   p_position_id = position_id
    and   p_effective_start_date <= effective_start_date
    and ( asg.assignment_status_type_id = past.assignment_status_type_id
	  and past.per_system_status <> 'TERM_ASSIGN')
    -- start changes for 8357127
    and   assignment_type in (
    -- added in 12631799
          select assignment_type
          from per_all_assignments_f
          where assignment_id = p_assignment_id
          and  p_effective_start_date between effective_start_date and effective_end_date
          )
    -- end changes for 8357127
    order by asg.effective_start_date asc;