How to Access Approval DB Table
Approval actions are stored in AO_7B9828_TIMESHEET_APPROVAL table. There is an entry for each user_key/period_id/project_id combination. STATUS column can have one of the following values:
APPROVED
PARTIALL_APPROVED
SUBMITTED
OPEN
REJECTED