Product: | HXT - Time and Labor |
---|---|
Description: | |
Implementation/DBA Data: | APPS.HXT_ERRORS |
SELECT "ID"
, "ERROR_MSG"
, "LOCATION"
, "ERR_TYPE"
, "TIM_ID"
, "HRW_ID"
, "PTP_ID"
, "ORA_MESSAGE"
, "PPB_ID"
, "PAYROLL_ID"
, "PERSON_ID"
, "EFFECTIVE_END_DATE"
, "EFFECTIVE_START_DATE"
, "CREATED_BY"
, "LAST_UPDATED_BY"
, "LAST_UPDATE_DATE"
, "LAST_UPDATE_LOGIN"
, "CREATION_DATE"
FROM HXT_ERRORS_F
WHERE EFFECTIVE_START_DATE <= (SELECT EFFECTIVE_DATE
FROM FND_SESSIONS FNDS
WHERE FNDS.SESSION_ID = USERENV('SESSIONID'))
AND EFFECTIVE_END_DATE >= (SELECT EFFECTIVE_DATE
FROM FND_SESSIONS FNDS
WHERE FNDS.SESSION_ID = USERENV('SESSIONID'))