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