6461:
6462: Cursor GetWorkTypeInfo(P_Work_Type_Id IN PA_Work_Types_B.Work_Type_Id%TYPE) IS
6463: select
6464: name 6465: from pa_work_types_v w 6466: where w.work_type_Id = P_Work_Type_Id
6467: and p_Exp_Item_Date between start_date_active and nvl(end_date_active, p_exp_item_date);
6468:
6469: /* end bug 4766396 */