905: l_Txn_Type_Id NUMBER;
906: CURSOR Txn_Type_Cur IS
907: SELECT ctt.Transaction_Type_Id Transaction_Type_Id
908: FROM CSI_Txn_Types ctt, 909: FND_Application fa 910: WHERE ctt.Source_Transaction_Type = P_Txn_Type
911: AND fa.application_id = ctt.Source_Application_ID
912: AND fa.Application_Short_Name = P_App_Short_Name;
913: BEGIN