APPS.HRWSDPR SQL Statements

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

Line: 10

  	select period_name, start_date, end_date
  	from   per_time_periods  ptp
  	where  p_payroll_id	= ptp.payroll_id
	and    p_given_date	between ptp.start_date and ptp.end_date
	and    ptp.start_date   <= p_session_date;