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