201: Begin
202: IF P_Work_Type_Id is NOT NULL THEN /* IF Added for Bug2220691*/
203: Select Tp_Amt_Type_Code
204: into l_Tp_Amt_Type_Code 205: from Pa_Work_Types_Vl 206: where Work_Type_Id = P_Work_Type_Id;
207: ELSE
208: l_Tp_Amt_Type_Code:=NULL; /* Bug 2220691 */
209: END IF;