APPS.PA_WORK_TYPE_UTILS dependencies on PA_WORK_TYPES_B

Line 31: 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

27: -- Validate ID based on the check id flag
28: IF p_check_id_flag = 'Y' THEN
29: SELECT work_type_id
30: INTO x_work_type_id
31: 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
32: WHERE work_type_id = p_work_type_id
33: AND TRUNC(SYSDATE) BETWEEN start_date_active
34: AND NVL(end_date_active,TRUNC(SYSDATE));
35: ELSE

Line 115: FROM pa_work_types_b w -- changed pa_work_types_v to pa_work_types_b for performance issue. Refer Bug: 4668829

111: FROM pa_tasks t
112: WHERE t.task_id = p_task_id;
113: CURSOR work_type_cur IS
114: SELECT w.BILLABLE_CAPITALIZABLE_FLAG
115: FROM pa_work_types_b w -- changed pa_work_types_v to pa_work_types_b for performance issue. Refer Bug: 4668829
116: WHERE w.work_type_id = p_work_type_id;
117:
118: l_proj_type_rec Get_Project_type_class_cur%ROWTYPE;
119: l_proj_rec Get_Project_type%ROWTYPE;