Refer to the Implementation Guide, 11i Oracle Self Service Time. On page 2-2 the documentation is specific on modifying the PA_ONLINE_EXPENDITURE_TYPES_V using file pavw742.sql found in the $PA_TOP/patch/115/sql directory.
You can configure Self–Service Time poplists for projects, tasks, expenditure types, and overriding approvers to meet your requirements. To do this, modify the WHERE clause in the corresponding view listed in this section. The views control the project and task values that users can download from the View Projects and Tasks link on the Self–Service Time main menu. Views are associated with the timecard preparer (that is, the person logged into the system). Because these views are used for validation and display, be sure to set up the the view so that the timecard preparer can select the projects for which he is entering hours. You can customize the following views:
Project View PA_ONLINE_PROJECTS_V : pavw681.sql
*Default allows user to view all projects. Sample code specifies that projects selected must be within the user’s organization. Do not modify the base view PA_PROJECTS_EXPEND_V.
Task View PA_ONLINE_TASKS_V : pavw682.sql
*Default allows user to view all tasks. Sample code specifies that tasks selected must be within the user’s organization. Do not modify the base view PA_TASKS_EXPEND_V.
Expenditure Type View PA_ONLINE_EXPENDITURE_TYPES_V : pavw742.sql
*Default allows user to view all expenditure types. Sample code specifies that users in the Consulting organization (organization_id=1) can enter only transactions of type Straight Time. Do not modify the base view PA_ONLINE_EXPENDITURE_TYPES_V.
Overriding Approver View PA_EXP_OVRRDE_APPROVER_V : pavw685.sql
*Default allows user to view all supervisors in the preparer’s business group. Sample code specifies that users can only select overriding approvers who belong to the user’s organization.
-> * Scripts are located in the $PA_TOP/patch/115/sql directory.