SELECT id ,effective_start_date ,effective_end_date ,assignment_id ,autogen_hours_yn ,rotation_plan ,earning_policy ,shift_differential_policy ,hour_deduction_policy ,created_by ,creation_date ,last_update_date ,last_update_login ,last_updated_by ,attribute_category ,attribute1 ,attribute2 ,attribute3 ,attribute4 ,attribute5 ,attribute6 ,attribute7 ,attribute8 ,attribute9 ,attribute10 ,attribute11 ,attribute12 ,attribute13 ,attribute14 ,attribute15 ,attribute16 ,attribute17 ,attribute18 ,attribute19 ,attribute20 ,attribute21 ,attribute22 ,attribute23 ,attribute24 ,attribute25 ,attribute26 ,attribute27 ,attribute28 ,attribute29 ,attribute30 FROM HXT_ADD_ASSIGN_INFO_F WHERE EFFECTIVE_START_DATE <= TRUNC(SYSDATE) AND EFFECTIVE_END_DATE >= TRUNC(SYSDATE)
SELECT ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, ASSIGNMENT_ID
, AUTOGEN_HOURS_YN
, ROTATION_PLAN
, EARNING_POLICY
, SHIFT_DIFFERENTIAL_POLICY
, HOUR_DEDUCTION_POLICY
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
FROM HXT_ADD_ASSIGN_INFO_F
WHERE EFFECTIVE_START_DATE <= TRUNC(SYSDATE)
AND EFFECTIVE_END_DATE >= TRUNC(SYSDATE)
|
|
|