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')
    order by asg.effective_start_date asc;