DBA Data[Home] [Help]

APPS.HXT_CLOCK_USER_EDITS SQL Statements

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

Line: 20

  SELECT person_id,
	 last_name,
         first_name
    INTO o_person_id,
	 o_last_name,
	 o_first_name
    FROM per_people_f
   WHERE employee_number = i_employee_number
     AND i_date_worked BETWEEN effective_start_date
                           AND effective_end_date
     AND business_group_id = i_business_group_id;