APPS.PA_WORK_TYPE_UTILS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 29

           SELECT work_type_id
           INTO   x_work_type_id
           FROM   pa_work_types_b --pa_work_types_v changed pa_work_types_v to pa_work_types_b for performance issues. Refer Bug:4668829
           WHERE  work_type_id = p_work_type_id
             AND TRUNC(SYSDATE) BETWEEN start_date_active
                                    AND NVL(end_date_active,TRUNC(SYSDATE));

Line: 40

        SELECT work_type_id
        INTO   x_work_type_id
        FROM   pa_work_types_v
        WHERE  name = p_name
          AND TRUNC(SYSDATE) BETWEEN start_date_active
                                 AND NVL(end_date_active,TRUNC(SYSDATE));

Line: 102

 SELECT p.project_type_class_code
 FROM pa_project_types p
 WHERE p.project_type = l_project_type;

Line: 106

 SELECT a.project_type
 FROM pa_projects a
 WHERE a.project_id = l_project_id;

Line: 110

 SELECT t.project_id
 FROM pa_tasks t
 WHERE t.task_id = p_task_id;

Line: 114

 SELECT  w.BILLABLE_CAPITALIZABLE_FLAG
 FROM pa_work_types_b w  -- changed pa_work_types_v to pa_work_types_b for performance issue. Refer Bug: 4668829
 WHERE w.work_type_id = p_work_type_id;