[Home] [Help]
VIEW: APPS.HXC_STATIC_TIMECARD_INFO_V
Source
View Text - Preformatted
SELECT person_id ,full_name ,employee_number from per_people_f where sysdate between effective_start_date and effective_end_date
View Text - HTML Formatted
SELECT PERSON_ID
, FULL_NAME
, EMPLOYEE_NUMBER
FROM PER_PEOPLE_F
WHERE SYSDATE BETWEEN EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE